customizing reports
I’m trying to escape Quicken and return to double entry accounting with gnu cash. But creating/customizing reports has me stumped! Let's say I have 20 customers each paying monthly for a service. I'd like to track the payments over a 12 month period for all 20 customers. What kind of report can I create with gnu cash, so each customer will be a row and in each column, that customer's payment will be seen in the month it was paid? An application might be collecting rents from 20 tenants. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Screen goes black when trying to change split transaction
Using MacOS High Sierra I want to change the transfer account Double click the entry line, and get the Message, "Change split linked to a reconciled split?" Click button "Change Split" Screen goes completely black Have to force quit to get back to screens. Can anyone help? DW ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Farmer Question
I made a similar decision about ten years ago and migated from Quickbooks for almost identical reasons. I do my own books to trial balance where an accountant presents them for taxation. I did it for a similar reason and dispensed with Microsoft. HMRC.'s Paye Tools have a Linux version which works faultlessly. I am VAT. registered and reclaiming presents no problems either. I use OpenOffice Calc & Base for ration calculations, irrigation need and my arable database. I do still use an ancient version of Microsofr in a Virtual Box to run InterHerd, I am in my late seventies and I don't think you have anything to fear from migrating. I think there is a learning curve but negotiating it will teach you a lot about good accountancy practice ! Paddy ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: How to best keep track of tax liabilities of a sole proprietorship
> On Jan 9, 2018, at 8:04 PM, Chris Smith wrote: > > I am using GnuCash for my freelance business. My dad always taught me to > set 30% of a check aside for the government's share. > > How would you enter this to keep track of the tax liability? I am thinking > I'd have to enter it against my *Income:Sales* account as a transfer to > *Liabilities:Tax* > > I figure at the end of the year *Asset:Checking Account* can transfer to > satisfy the true Tax liability. > > One thing to note, I *don't* want the liability to effect reports on sales > reports. :/ > > Am I just overthinking this? > > -- > Chris > > What I do so I have a basic idea of what my income/expenses are is to make an expense for taxes and a liability for taxes and do a transaction between those two each month. And then when I pay the taxes, the transaction is between the checking account and the liability tax account. So it won't affect income, but it will affect your net income (income - expenses) as it should. Others may chime in with more definitive answers as IANAA. HTH, Dave ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: How to best keep track of tax liabilities of a sole proprietorship
My basic approach to such questions is to think about the "5 W's" of reporting (after all, "accounting" is fundamentally about telling an accurate story of what is going on with your money. How you tell that story is dependent on what the standard practices in your local jurisdiction, as well as how you choose to think of things. Here's how I would think about it. *What* are the taxes? Taxes that I pay are fundamentally an expense, so I will need an "Expense:Taxes" account. For me in the US, I'd probably break that down into different tax accounts based on the nature of the tax (Federal income tax, State income tax, property taxes, self-employment tax, FICA/Medicare, etc). I may also be asked to collect taxes ultimately owed by other people, such as wage withholdings from my employees, or sales taxes on goods/services sold. These are funds I have, but aren't mine, and don't count as income or expenses for me. Rather, they are liabilities. *Where* is the money? If I haven't paid the taxes yet, the money is in a bank account. After I send off the check, I don't have it any more. *When?* This is multiple questions. When do I recognize the expense? When do I cut the check? What's the overall timing? There are a few ways to go about this. One way is to work off a "cash" basis: the tax expense doesn't occur until the check is cut and paid (when you fill out your annual tax return), but you want to set the money aside as you go so you have the cash to pay it. Of course, you are setting aside an estimate, since many cases you won't know your actual tax liability until you pay it. In that case, I'd would open a 2nd bank account and split your deposit between your main account and this tax reserve account: 6 June 2017: Receive payment from Acme Inc for consulting work Income:Consulting Cr. $1000 Asset:Bank:Checking Db. $700 Asset:Bank:Tax Reserve Db. $300 15 April 2018: Income Tax Payment Asset:Bank:Tax Reserve Cr. $300 Asset:Bank:Checking Cr. $25 Expense:Taxes:Income Db. $325 Another way is to recognize the tax on an ongoing basis, "paying" it from a liability account. : 6 June 2017: Receive payment from Acme Inc for consulting work Income: Consulting Cr. $1000 Asset:Bank:Checking Db. $1000 Expense:Taxes:Income Db. $300 Liability:Unpaid Taxes Cr. $300 15 April 2018: Income Tax Payment Asset:Bank:Checking Cr. $325 Liability: Unpaid Taxes Db. $300 Expense:Taxes:Income Db. $25 You might be required to prepay estimated taxes during the year, especially if your estimated tax liability gets too large: 6 June 2017: Receive Payment from Acme Inc for consulting work Income: Consulting Cr. $1000 Asset:Bank:Checking Db. $1000 15 July 2017: Estimated Tax Payment Asset:Bank:Checking Cr. $300 Asset:Prepaid Taxes Db. $300 15 April 2018: Income Tax Payment Asset:Bank:Checking Cr. $25 Asset:Prepaid Taxes Cr. $300 Expense:Taxes:Income Db. $325 Which is best, or proper, will depend on local law and practice, which we (obviously) cannot advise you about. On Wed, Jan 10, 2018 at 9:58 AM wrote: > > > > On Jan 9, 2018, at 8:04 PM, Chris Smith wrote: > > > > I am using GnuCash for my freelance business. My dad always taught me to > > set 30% of a check aside for the government's share. > > > > How would you enter this to keep track of the tax liability? I am > thinking > > I'd have to enter it against my *Income:Sales* account as a transfer to > > *Liabilities:Tax* > > > > I figure at the end of the year *Asset:Checking Account* can transfer to > > satisfy the true Tax liability. > > > > One thing to note, I *don't* want the liability to effect reports on > sales > > reports. :/ > > > > Am I just overthinking this? > > > > -- > > Chris > > > > > > What I do so I have a basic idea of what my income/expenses are is to make > an expense for taxes and a liability for taxes and do a transaction between > those two each month. And then when I pay the taxes, the transaction is > between the checking account and the liability tax account. > > So it won't affect income, but it will affect your net income (income - > expenses) as it should. > > Others may chime in with more definitive answers as IANAA. > > HTH, > Dave > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: customizing reports
I’ve seen such a report your describe in other software, but only for one customer at a time and only as an indicator of “y/n” as to if a regular monthly payment was made, not the actual amount. I don’t think such a report currently exists that displays the info the way you prefer. You’d have to write your own report. (daunting indeed) There are options to writing a report from scratch, but they aren’t much better with respect to learning curve. If you are using the MySQL backend, you could query the database directly and use the results of the query in a report. I think there is also something called PyCash that will allow you to access some data from outside GnuCash using Python which you could then use to generate the report you want. Otherwise, the reports that are available include the Customer Report & Receivable Aging report. The Customer Report will show each invoice and payment (done through the business features) for any specified period. But this is one customer at a time. Think of it as a Statement of Account. The Receivable Aging report will show all customers, but shows you which ones are late (30 days, 60 days, etc.) Again, this pulls data through the use of the business features only. (you’ll need to be issuing invoices and processing payments) If you aren’t up for writing a report either directly for GnuCash or outside of it using SQL queries or Python, you can always track what you want in a spreadsheet separately. There is one other option that will at least display if an invoice is paid or not so you can see if any customers missed a payment. You can do an invoice search to show all invoices which will give you a list of all of your invoices with a checkbox column that shows if they are paid or not. However, this list will show each invoice per line (instead of each customer as you requested) and the list is not exportable, best I can tell. To show all invoices change the search criteria to “matches regex” and use a “.” as the search term. Regards, Adrien > On Jan 5, 2018, at 5:54 PM, richard.cour...@verizon.net wrote: > > I’m trying to escape Quicken and return to double entry accounting with gnu > cash. > > But creating/customizing reports has me stumped! > > > > Let's say I have 20 customers each paying monthly for a service. > > I'd like to track the payments over a 12 month period for all 20 customers. > > What kind of report can I create with gnu cash, so each customer will be a > row and in each column, that customer's payment will be seen in the month it > was paid? > > > > An application might be collecting rents from 20 tenants. > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Read only transactions
Hi I still haven't sorted my Quicken import, getting the correct balances without a 'balance adjustment' is difficult. But the question is: How do i delete an account when it contains read only transactions? I know i can move the transactions elsewhere, but I need to delete the accounts. I understand that the 'placeholder box' needs to be unchecked; it already is. Need a solution, Google yields nothing. thanks Cliff ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Farmer Question
On 1/9/2018 5:14 PM, James Meade wrote: > I've used Quicken for years and am considering switching to gnucash > mainly because Quicken is going to a subscription pay model and I > don't want to be held hostage by it or by an operating system (I > always have in the back of my mind to swithc from Windows to Linux). > I know little of accounting. In reading the manuals, I have a number > of questions about setting up the gnucash system. > First export your data from Quicken, then import it into a new GnuCash file. Their are several links you can google on how to do this. Once that is done then you can see your real account structure. I discovered, when I changed from Quicken, that I had wrong categories going back 20+ years. Plus I am tired of buying new versions of Quicken every 3 years, and a new version of Windoze just because Micro$oft says so. I would recommend that you do both Quicken and GnuCash simultaneously for at least a month just to learn the difference. Then make your decision between a pay as you go Windoze setup, or GnuCash. GnuCash is platform independent, so if you make the switch to Unix, so is your data. That's my plan too! > 1. I have several checking accounts and use them all for both personal > and business use. It seems unfeasible to set up two sets of books. > Can/how do I separate personal from business in one set of books? > All you need is one file, which is advisable since you intermix business and personal usage with multiple checking accounts. That is the way mine is set up. The separation of business and personal income/expense is easy. All you need is a top level account for each type of transaction ie. personal, my farm, aviation, etc. Then under each of those there would be sub-accounts for each type of transaction. If you pay say for a haircut with a check from Bank A. Then when you post it, select Bank A. Then start filling in the blanks, you debit Bank A $6, you then credit Expenses Personal:Haircut $6. Same for business, each business will have it's own list of expense/income accounts. > 2. I have several credit cards, use them the same way as checking. How > do I set up several credit card sub accounts, e.g., notional names AB > Visa, CD Mastercard, EF Visa, etc., and separate purchases for > business and personal? You will will have a credit type account for each one. Select the Account tab, then Actions, then Add Account. I would move them all to individual top level account, ie. Personal Credit Card, then change AB Visa, CD Mastercard, etc to children of Personal Credit Card. Same for business credit cards, Business Credit Cards:EF Visa. Posting would be same as in Question 1. Note: the ":" is a separator between account names. > > 3. I do all my data entry manually and am not going to change. > Not a problem, enter all of them you want to by hand. Electronic entry is not mandatory. > 4. I have several income streams, including farming, flight > instruction, writing, custom farming (e.g., mowing or plowing for > someone else), military retirement, social security benefits. Some are > business and some are personal. Any thing to consider when I set them > up? > Nope. Just set each of them up as income accounts. Again I would group them by type. ie. Custom farming income:Plowing Custom farming income:hay baling .. I would create any grandchildren accounts as needed for tax line item entry. If I remember correctly social security benefits have to be broken out for taxes. > As I see it, my main uncertainties are about mixing personal and > business and about having a number of different accounts of the same > type that are used for both personal and business (i.e., checking and > credit cards). > Do not worry about it, you did not when you made the purchase or income. You simply post the transaction to the right paying account then split the total amount among the other accounts as needed. It's similar to Quicken, except you do not open a split window or enter a tag. You split right there in the transaction, the total on the left column has to match the right hand column. Your personal expense account may have Expense:Auto:gasoline. Your farm account may have My Farm Expense:gasoline. They are different expenses as they should be, even if you bought them at the same time. Farm fuel is deductible, your joyride gasoline is not. > It occurs to me that if I have to ask these questions the prospect of > using double-entry bookkeeping may be more than I should attempt. If > you think that is the case feel free to say so. I'm trying to figure > out if I want to go this way. I tried QuickBooks about 8-10 years ago > and gave it up after a couple of months. I have the time and energy > to put in, just not sure if I'm smart enough. > Go for it!!! How can you learn if you do not try? Double entry is not as hard as you think it is. It is just takes a little
Re: customizing reports
Hello Richard If you have some programming experience, I can provide you some help to achieve what you want through piecash (for the python programming language). Sebastien On Jan 10, 2018 18:32, "Adrien Monteleone" wrote: > I’ve seen such a report your describe in other software, but only for one > customer at a time and only as an indicator of “y/n” as to if a regular > monthly payment was made, not the actual amount. I don’t think such a > report currently exists that displays the info the way you prefer. You’d > have to write your own report. (daunting indeed) > > There are options to writing a report from scratch, but they aren’t much > better with respect to learning curve. > > If you are using the MySQL backend, you could query the database directly > and use the results of the query in a report. > > I think there is also something called PyCash that will allow you to > access some data from outside GnuCash using Python which you could then use > to generate the report you want. > > Otherwise, the reports that are available include the Customer Report & > Receivable Aging report. > > The Customer Report will show each invoice and payment (done through the > business features) for any specified period. But this is one customer at a > time. Think of it as a Statement of Account. > > The Receivable Aging report will show all customers, but shows you which > ones are late (30 days, 60 days, etc.) Again, this pulls data through the > use of the business features only. (you’ll need to be issuing invoices and > processing payments) > > If you aren’t up for writing a report either directly for GnuCash or > outside of it using SQL queries or Python, you can always track what you > want in a spreadsheet separately. > > There is one other option that will at least display if an invoice is paid > or not so you can see if any customers missed a payment. You can do an > invoice search to show all invoices which will give you a list of all of > your invoices with a checkbox column that shows if they are paid or not. > However, this list will show each invoice per line (instead of each > customer as you requested) and the list is not exportable, best I can tell. > To show all invoices change the search criteria to “matches regex” and use > a “.” as the search term. > > Regards, > Adrien > > > On Jan 5, 2018, at 5:54 PM, richard.cour...@verizon.net wrote: > > > > I’m trying to escape Quicken and return to double entry accounting with > gnu cash. > > > > But creating/customizing reports has me stumped! > > > > > > > > Let's say I have 20 customers each paying monthly for a service. > > > > I'd like to track the payments over a 12 month period for all 20 > customers. > > > > What kind of report can I create with gnu cash, so each customer will be > a row and in each column, that customer's payment will be seen in the month > it was paid? > > > > > > > > An application might be collecting rents from 20 tenants. > > > > > > --- > > This email has been checked for viruses by Avast antivirus software. > > https://www.avast.com/antivirus > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
