Re: [GNC] QIF import - Loss of sign
On Saturday, 23 February 2019 03:37:15 GMT Rustyc wrote: > Derek - Second question re your response: > > > > Edit the account in question and check on the account type. > > Looked at the Account but could not see an option anywhere to specify > "Account Type" - apart from "Asset", "Expense" etc. Does it depend on > Account Code or Name (in some way)? > Hi Rusty. That sounds like you are in the correct dialogue box - the "Account Type" dropdown should have "Bank" and "Credit Card" and several others including Asset & Expense you mention. Just set the Bank account to type "Bank" and put it in the Assets parent section in your tree. (you can re-parent accounts at any time if you find you need to make the tree more complicated, eg a folder of different bank accounts etc.) HTH, Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash for a Letting Agency (holding client money)
Oli, For the situation where you have to bill a tenant you may want to look at the invoicing features of the business features https://www.gnucash.org/docs/v3/C/gnucash-help/chapter_busnss.html. Using these features is described in the tutorial guide here https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_bus_features.html. These is also information in the wiki here https://wiki.gnucash.org/wiki/Business_Features_Issues. These allows you to issue an invoice to the tenant and then record the payment against the invoice when the tenant pays the rent and outstanding charges. The invoice raises an entry against an Account Receivable account. The Business->Customer->New Invoice will create the following transaction (acccount names are indicative only) which records that the tenant owes you money and that you will receive that amount in income. You will be prompted to create a customer record during this process if the customer is anew customer Tot Invoice Tot Payment Asset:Accounts Receivable 80 records the tenant owes you 80 Income:Tenant Services 80 records you have earned 80 lets assume as you indicated that the tenant then pays this with his next rent payment using the amounts you indicated earlier You can use the Business->Customer->Process payment and select the customer you created above. This will display any outstanding invoices for that customer and you would select the above invoice to pay. In this dialog you will select the transfer account, i.e. the account that the money has been paid into by the tenant, i.e. Asset:Bank:Cheque. This will display the amount owing for the invoice by default but you can replace that with the total payment and will open the register for the Accounts Receivable account. The first two entries should be created by default. You can create the next two lines by using the tab key skip through fields to open a new line and then select the libility account and enter the amount you will owe to the owner. Again use the tab key to skip fields to open the next line and select the income account for the amount you receive from the payment as fees. Tot Invoice Tot Payment Asset:Bank:Cheque 1080 records the tenant has paid you 1080 Asset:Accounts Receivable80 records that the tenant has paid 80 Liability: Rent Collected 900 records that the tenant has paid 900 which belongs to the owner Income:Rental Fees100 records the fess you are paid for collecting rent At some point you will pay the owner the collected rent. You would record this as follows: Deposit Withdrawal Asset:Bank:Cheque900 you paid money to the owner out of your bank account Liability:Rent Collected 900 and reduced your liabilty to the owner. Similarly you can treat the owners as customers also when you provide them with services and invoice them for those services in the same manner as above. If they don't pay these invoices directly but you pay them from the collected rent you could make the payments by reducing the Liability: Rent Collected by a deposit of the amount of the service and making the payment to the Asset:Accounts Receivable by slecting the accounts as follows in the Business->Customer->Process Payment dialog. Decrease Increase Liability: Rent Collected xxx Asset:Accounts Receivablexxx A CPA is a Charted Practising Accountant or a Certified Practising Accountant, i.e. an accounting professional who will have knowledge of accounting practice and business legislation in the legal jurisdiction in which you carry out your business and can advise you on what records you need to keep, account heirarchies which are appropriate, any reporting requirements etc. If you can find a good one they are worth their weight in gold. If you are setting up a business you really need good legal and accounting advice if you are not familiar with the requirements. Any advice you may get here is generic and illustrative only and about how to use GnuCash not how to do accounting or how to meet any legal requirements in running a business. It may or may not be exactly relevant to your situation and jurisdiction. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___
[GNC] insurance policy with guaranteed value: how to record increase in value?
Hello. I have an insurance policy which works like this: - after the initial payment, I could make additional payments, up to a month ago, and I did. - the company has to have 100% backing for the money received by customers for this product, meaning all of them could theoretically ask money back at the same time and it would be possible for the company to reimburse the sums with no ill effects (so called "Gestione Separata" in Italian) - there is a revaluation guarantee at 0%: regardless of the performance of the investments made by the company (typically a few percent points per year), the worse it can happen is that I earn nothing for one or more years; what is already consolidated from the previous year, stays there. - it's an insurance policy so there are additional benefits but those are not relevant to my question. Having said that, I wonder how to properly record the current value for this investment: at the moment, the account type is "Attività" (asset) and I have already recorded the commissions paid as costs. In the meanwhile, one year has passed and the value has incresed. I cannot use the price editor, because this product doesn't really have shares like in the stock exchange or like managed investment funds. I mean, I could change the account type but it would make no sense to me. Is there a way to do it with the price editor? I would need to record a new total value, instead of a new commodity unit value. Given the revaluation guarantee, I could simply record the difference between the new and the previous values as a gain and be done with it. Does it seem reasonable? Thanks, Andrea. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QIF import - Loss of sign
On Fri, Feb 22, 2019 at 10:16 PM Rustyc wrote: > Have read manuals, set up a chart of accounts and started by importing a > QIF file of bank transactions thinking this would be the quickest way to > get going. > When you performed the import process, there's a step where you are supposed to assign accounts for each transaction. It sounds like you skipped it. If you start over, delete the account and recreate it, or start from a backup, and assign the accounts as you import, then this will also train the importer to auto-assign for future imports. I'll explain below how to edit them from the current state if you'd rather do that. > I end up with two entries for each transaction but there is no indication > of which entry is for the bank transaction and which is the one I have to > assign to another GnuCash account (which is what I presume is what is > required). The plus and minus signs in the QIF have disappeared. Am I > missing something? > GnuCash never displays a minus sign. Instead, you should find that a line has an amount in one of the two columns, but never both. It's a different way of displaying the same information. Also the manual states that “Debit and Credit” terms can be replaced with > “Deposit and Withdrawal” for newbies. However, Account view shows columns > labelled “Increase and Decrease”. Confusing! Can someone explain. If you don't have "formal accounting terms" turned on then GnuCash will use different terms depending on the type of the account, attempting to refer to what you are (usually) doing when that type of transaction occurs. "Deposit" and "Withdrawal" are used for bank accounts. "Payment" and "Charge" are used for credit cards. "Expense" and "Rebate" are used for expense accounts. ...and so on. "Increase" and "Decrease" are the generic terms for account types that don't have specific terms. Increases (in the value of that account) are always in the left column and decreases are always in the right column. So for example, if you wanted to correct a transaction that is *outgoing* money, in a bank account, and erroneously pointing back to the same account instead of an expense account, you would find the version of it which has the amount listed in the "Withdrawal" column, then edit the "Transfer" column to specify the correct other account. Once you complete that, the second copy in the same account's register will disappear. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] insurance policy with guaranteed value: how to record increase in value?
Ah, my line of country, insurance. Some questions (details) a) Do they not give you an annual statement? One that indicates increase in "cash value". b) I do not QUITE understand the guaranteed return of 0% UNLESS that is increase in value OTHER than the component from "survivorship". If including "survivorship" (the fact that you are now a year older --- you did NOT die in the previous year) this would be a terrible product compared to what where I used to work would offer. In other words, is that 0% a guarantee on the "investment" component? Assuming you get an annual statement, you could adjust manually at that time. The asset would go under "fixed assets" and you are correct that you would not be using the "price editor". Michael D Novack FLMI On 2/23/2019 6:54 AM, Andrea Borgia wrote: Hello. I have an insurance policy which works like this: - after the initial payment, I could make additional payments, up to a month ago, and I did. - the company has to have 100% backing for the money received by customers for this product, meaning all of them could theoretically ask money back at the same time and it would be possible for the company to reimburse the sums with no ill effects (so called "Gestione Separata" in Italian) - there is a revaluation guarantee at 0%: regardless of the performance of the investments made by the company (typically a few percent points per year), the worse it can happen is that I earn nothing for one or more years; what is already consolidated from the previous year, stays there. - it's an insurance policy so there are additional benefits but those are not relevant to my question. Having said that, I wonder how to properly record the current value for this investment: at the moment, the account type is "Attività" (asset) and I have already recorded the commissions paid as costs. In the meanwhile, one year has passed and the value has incresed. I cannot use the price editor, because this product doesn't really have shares like in the stock exchange or like managed investment funds. I mean, I could change the account type but it would make no sense to me. Is there a way to do it with the price editor? I would need to record a new total value, instead of a new commodity unit value. Given the revaluation guarantee, I could simply record the difference between the new and the previous values as a gain and be done with it. Does it seem reasonable? Thanks, Andrea. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- There is no possibility of social justice on a dead planet except the equality of the grave. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash for a Letting Agency (holding client money)
Oli, David answered everything else so on this point below I’ll suggest this question: Are these one-off projects part of or incidental to your letting business? If so, then simply create invoices for them as customers as normal. If not and this side-work is unrelated, then you need to ask yourself another question: Is the Letting Agency a legal passthrough, or a separate legal entity? Here is where you really need to speak to a local business attorney *and* CPA. If the Letting Agency is a separate legal entity from you and files separate tax returns, then you probably need to also have a personal GnuCash file. These one-off side jobs would be recorded there. Having separate books might very well be a legal requirement. If on the other hand, you file a single personal return and there is no separate legal entity, then everything is ‘your activity’ and you *can* put it all in the same file or ‘book’. I emphasized ‘can’ because in this case, it would be your choice. You can still keep separate books if you like. Regards, Adrien > On Feb 22, 2019, at 7:07 AM, zcacogp wrote: > > > - Occasionally I do one-off projects for people who are not landlords. This > leads to a regular invoice being raised and the client paying me the amount > owed. This is different from the 'usual' situation as there is no rent to > consider, just an invoice being raised and then being paid. > > > Oli. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash for a Letting Agency (holding client money)
Oli, There is one other aspect we haven't touched on. When you are collecting cash directly from tenants/customers you may have cash which you have collected which is not yet deposited at the bank. Rather then recording the cash payments directly into your Bank cheque account it is a common practice to record the undpeosited payments to an Asset:Bank:Undeposited Funds account in the first instance and then record the transfer to your cheque account when the funds are actually deposited into your account, particularly if there is any significant delay in depositing them. Becoming less of an issue with direct online crediting these days but here you can have clearance times into your bank account to consider although these are now also getting so short that they are unlikely to be generally a problem. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cloud storage for shared access?
Em sáb, 23 de fev de 2019 às 03:23, Stephen Mudge < stephen.mudge.nor...@gmail.com> escreveu: > Hi there. . . . > > If I move *the account I have set up on my pc* to a cloud drive like > Dropbox > or Google drive, would I be able to access it through the *mobile app* to > add > expenses while "in the field"? > > Many thanks. > Steve > Hi Steve, If what you call "*account I have set up on my pc*" is the Gnucash Desktop (GD) XML file and what you call the "*mobile app*" is GnuCash Android (GA ) . . . , you can transfer your XML data file from your GD via DropBox, Google Drive or another way to your Android and open it in your GA, edit it in GA, then you can export XML in GA to the Dropbox (Google Drive is not supported by GA), download the XML in the PC and open it in the GD. But . . . there are other ways of transferring information between GD and GA. -- Regards GTI ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash for a Letting Agency (holding client money)
I’ll add that this type of account is also useful for paper checks which have not yet been deposited, not just cash. Regards, Adrien > On Feb 23, 2019, at 8:33 PM, David Cousens wrote: > > Oli, > > There is one other aspect we haven't touched on. When you are collecting > cash directly from tenants/customers you may have cash which you have > collected which is not yet deposited at the bank. Rather then recording the > cash payments directly into your Bank cheque account it is a common practice > to record the undpeosited payments to an > > Asset:Bank:Undeposited Funds > > account in the first instance and then record the transfer to your cheque > account when the funds are actually deposited into your account, > particularly if there is any significant delay in depositing them. Becoming > less of an issue with direct online crediting these days but here you can > have clearance times into your bank account to consider although these are > now also getting so short that they are unlikely to be generally a problem. > > David Cousens ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cloud storage for shared access?
On Sat, 23 Feb 2019 23:53:17 -0300 "GTI .H" wrote: > Hi Steve, > > If what you call "*account I have set up on my pc*" is the Gnucash > Desktop (GD) XML file and what you call the "*mobile app*" is GnuCash > Android (GA ) . . . , you can transfer your XML data file from your > GD via DropBox, Google Drive or another way to your Android and open > it in your GA, edit it in GA, then you can export XML in GA to the > Dropbox (Google Drive is not supported by GA), download the XML in > the PC and open it in the GD. > > But . . . there are other ways of transferring information between GD > and GA. > > > -- > Regards > GTI one additional step The Android App compresses the xml, so it needs decompressing before you can import it. Its' caught us all at some time! Liz ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Are there any add-on modules for Gnucash
On 21/02/2019 21:03, Adrien Monteleone wrote: Otherwise, if you have a case of say, high volume day trading, you are probably limited to tracking most of the activity outside of GnuCash, generating daily net transactions and just entering/importing those. Good advice, Adrien. The gnc data model fails if you push it too hard. -- Wm ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Are there any add-on modules for Gnucash
On 22/02/2019 15:34, John Ralls wrote: Our position has always been and will likely always be that we support writing to a GnuCash file or database only through the GnuCash API. That's not the same thing as from inside of GnuCash. Nods, in theory. GnuCash's libraries expose their API through the C calling convention that can be linked by just about any compiled language. You'll need to get the sources for the headers. We also provide Python 3 and Scheme (via Guile) bindings for parts of the API, though the Python bindings aren't built in the Microsoft Windows or MacOS application bundles. That's where it gets weird. Do bear in mind that the GnuCash libraries aren't bullet-proof and it's still possible to wreck your database even with the GnuCash API if you're not careful (or are carefully malicious). Yikes! I haven't seen anyone I consider responsible doing that recently The API is complex and the documentation ranges from pretty good to nonexistent; it can be found at https://code.gnucash.org/docs/MAINT. in truth only a handful of people have a vague clue. On tho other hand, if you just want to create a bunch of transactions you might not need to code anything: The GnuCash 3.x CSV transaction importer is pretty capable. yes, the importer is improving, it is getting close to being able to read it's own tx. when it can do that well, you can introduce your own tx to the stream. -- Wm ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
