[GNC] QIF import - set default Transfer account
QIF import correctly imports data into the database.During import it sets all transactions as *'/Unspecified/'*.Is it possible to set a different Transfer account for ALL imported transactions ?BackroundAt the moment I am interested in just few types of expenses,95% of all imported transactions should be linked to my 'Other' expense account.I have lots of manual work to change the imported transactions -- 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] Handling of Equity and Retained Earnings
Adrien That is only true if in the new book all the transactions into Income and Expense accounts (to and from Asset and Liability accounts) are also brought into the new book (but why would you want to do that?) but if just the balances of the Asset and Liability accounts are transferred to the new book, then the Opening Balance entries in Equity automatically include the Retained Earnings to that point implicitly since at the point of closure of the old book we should have: Assets - Liabilities = Equity + (Income - Expenses) = Equity + Retained Earnings hence if we record the correct Asset and Liability balances with the second splits to Equity:OpeningBalances we are effectively transferring the value of Equity including the value of retained Earnings to the point of closure into the new book. Hope this makes this a bit clearer. David - 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] Handling of Equity and Retained Earnings
Someone moving from another application or from paper *would* have a non-zero Retained Earnings account that would *not* be reflected in the opening balances of the Asset or Liabilities accounts. The balance of that account would have been the result of closing Income and Expenses in previous years. In fact, I don’t see how carrying the Asset and Liabilities balances would even overall balance, without Retained Earnings. (or any other special Equity accounts, like “Owner’s Equity” or stock accounts, which may have previously existed in the books with carry-over balances) Yes, you’d create the following: Dr. Equity:Opening Balances Cr. Equity:Retained Earnings Just as was done with the Asset and Liability accounts. There is no need to carry over all of the Income and Expense accounts. They are zero anyway since those old books were closed. Now, if such a person wanted to *start from scratch* with GnuCash, then no, they wouldn’t need such an account. Regards, Adrien > On Jan 15, 2020 w3d15, at 3:32 PM, David Cousens > wrote: > > Adrien and Christian, > > Just a comment on Adrien's last post. There is no need to have an opening > balance for Retained Earnings. Any opening balance would be reflected in the > Equity entries when you enter the opening balances for the Asset and > Liability accounts (in a new book the Income and Expense Accounts should all > have zero balances) in the new book. If you wanted to create an opening > balance for Retained Earnings it would have to have Equity:Opening Balances > as the transfer account to maintain the correct balances carried forward. > The details of past Retained Earnings are recorded in the old book and > unless you also transferred all the transactions to retained earnings as > well your new book is not really going to contain any useful information you > would need to carry forward. > > 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.
[GNC] Problem with colons in account names
Hi, all. First, thanks for the continuing excellent work on Gnucash in the Dec. release. I know it is a lot of work for the team; it is not thankless work. I recently set up some stock stocks in the Security editor and created corresponding asset accounts as described in the documentation. The symbols I was given had colons in them, in the form symbol:currency, such as ABCD:USD, so I added these as the symbol and display symbol in the security editor. When I next started Gnucash I was warned that I had account names with colons, which is not true, I had securities linked to the accounts, and they had the symbols I just described. Regardless, I edited each of the securities to remove the trailing :USD parts, but I still see the warnings on starting up. Any suggestions for the correct fix are appreciated. Ron ___ 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] budget reports 'YTD' vs 'use accumulated amounts'
The updated budget report in 3.8 aims to display the YTD budget amounts. If it does not perform well then you'll need to file a bug. On Wed, 15 Jan 2020 at 23:48, larry johnston wrote: > Peter, > > I am still running 2.6.15. I am running Windows 10. Phil's report still > runs well in Wndows 10. > > I have not upgraded because I do not want to lose the functionality of > Phil's report. I do not download financial information from institution as > I do manual entry so have not seen any reason to upgrade. I am however > worried that if I wait too long I won't be able to access my data in a > later upgrade. > > Have you used the 'use accumulated totals' function in the newer versions? > I gather from what you state that you don't think it will > provide similar results to Phil's YTD refort. > > Larry > > On Sun, Jan 12, 2020 at 2:54 AM pj42uk wrote: > > > Larry, so far as I can tell the Standard report does not provide the YTD > > information. > > Phil's report does nor run properly on v 3.8 Windows 10. > > Is your experience any different? > > Peter > > > > > > > > -- > > 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. > > > ___ > 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. > ___ 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] budget reports 'YTD' vs 'use accumulated amounts'
Peter, I am still running 2.6.15. I am running Windows 10. Phil's report still runs well in Wndows 10. I have not upgraded because I do not want to lose the functionality of Phil's report. I do not download financial information from institution as I do manual entry so have not seen any reason to upgrade. I am however worried that if I wait too long I won't be able to access my data in a later upgrade. Have you used the 'use accumulated totals' function in the newer versions? I gather from what you state that you don't think it will provide similar results to Phil's YTD refort. Larry On Sun, Jan 12, 2020 at 2:54 AM pj42uk wrote: > Larry, so far as I can tell the Standard report does not provide the YTD > information. > Phil's report does nor run properly on v 3.8 Windows 10. > Is your experience any different? > Peter > > > > -- > 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. > ___ 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] Handling of Equity and Retained Earnings
On 1/15/2020 10:56 AM, Christian Lynbech wrote: Inspired by a recent discussion I would like to understand better how to handle the Retained Earnings equity sub account, as I am new to both Gnucash and accounting. In a world where books are closed at year end, I would understand Retained Earnings as sort of the surplus of the year that is then added to the equity so one starts the next year with a higher equity than the year before. When using Gnucash the recommended way of just keep going, there is not any real need to distinguish the year end result, it just goes into the rolling development of the accounts. However, at least here in Denmark, it is required for a company to produce a statement of balance and result, how could one handle that? Just make a report at year end that extracts the relevant numbers or simulate the closing of the books by moving the appropriate amount to Retained Earnings and then move it out again when the new year starts up? No, you just run the appropriate reports. It is going to help greatly if you tell us what a Danish "Statement of balance and result"might be. This is a terminology issue, just as the report called "Income Statement" in gnucash would be called "Profit and Loss" by a for profit entity and "Statement of Revenues and Expenses" by a non-profit entity. So we have trouble telling you which report(s) to run to get a "Statement of balance and result". What would be shown by this report? Is it for a point in time or for a time interval? Etc. Michael D Novack ___ 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] Handling of Equity and Retained Earnings
Adrien and Christian, Just a comment on Adrien's last post. There is no need to have an opening balance for Retained Earnings. Any opening balance would be reflected in the Equity entries when you enter the opening balances for the Asset and Liability accounts (in a new book the Income and Expense Accounts should all have zero balances) in the new book. If you wanted to create an opening balance for Retained Earnings it would have to have Equity:Opening Balances as the transfer account to maintain the correct balances carried forward. The details of past Retained Earnings are recorded in the old book and unless you also transferred all the transactions to retained earnings as well your new book is not really going to contain any useful information you would need to carry forward. 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] import export of transactions
John, The default delimiter is the comma but you can export data with any delimiter you choose and similarly import with any delimiter. If your data uses a comma as part of the data field, e.g. the comma used as a decimal separator, then the importer will incorrectly parse the data. Did your data format contain a comma in the date for example or at the start of the record? The importer also does not automatically distinguish between dd-mm-yyy and mm-dd- date formats and you also need to select the date format to match the format used in yourimport data. The locale information does not select this automatically. Your problem appers to have been solved so the above may help explain why a comma didn't work David - 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] import export of transactions
On 1/15/20 1:27 PM, John Griessen wrote: What delimiter to use? semicolon worked where comma failed. ___ 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.
[GNC] import export of transactions
What delimiter to use? I try comma and get that it can't parse, please add a date column, but I see no place to add that on the form... ___ 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] Formatting the Register header?
A transaction isn’t limited to only two splits, so there is no need to do ‘2 things’ each time. You can just make one transaction. With auto-fill or Duplicate Transaction you’re just going to be adjusting dates, check #s and maybe amounts. (and any notes/memos like “February Donation” or whatever you might want to add for yourself that might need to change) The accounts to use are a little messier. Ideally, you want to model real-world transactions as much as possible. This would be a case where you alter that due to wanting to track the pledge. Here’s where a bit of gymnastics with your Chart of Accounts comes in. The pledge is not an Accrued Expense (a liability account) because you don’t yet owe it. It is not a Pre-paid Expense (an asset account) because you haven’t paid it. It isn’t yet a regular Expense, and certainly not Income. Since it is at least a promise to pay, Liability is the best fit. You can have sub-accounts of Liabilities:Accounts Payable, or you can create other independent liability accounts. (and even an ‘Other Accounts Payable’ if needed) I would think the clearer option here would be to use another top-level account called Pledges. (of ’type’ liability) This allows for sub-accounts for each specific ‘xyz' (if needed) and keeps them entirely separate from your real liabilities, including your real AP. The disadvantage to not putting them under AP is they won’t roll up to show what you ’think you owe’ if that is important to you. You’d still have to do a little math on the side. (You could make it Liabilities:Pledges if you like, but I think it is cleaner to keep Pledges as top-level since it is a virtual account just for tracking purposes) You’ll need some way to start the pledge. Sticking with the idea of keeping virtual stuff separate, I’d say create one more account, Equity:Pledges, so your first transaction will look like: Dr. Equity:Pledges Cr. Pledges:xyz Now that you’re set up, the individual transactions would look like: Dr. Expenses:Charity Dr. Pledges:xyz Cr. Assets:Checking Cr. Equity:Pledges This moves money from Checking to Expenses, and reduces the pledge as well as partially reverses the opening balance Equity:Pledges entry. When you have finished your pledge for the year, Equity:Pledges will be zero, the liability Pledges/xyz account(s) will be zero, Expenses:Charity will reflect actual donations, and your Checking account will have been reduced accordingly. If at the end of the year you didn’t meet your pledge, you can carry it over and pledge the difference next year, (or the whole amount in addition) or just make one adjusting entry to zero the remainder of the pledge in the liability and equity tracking accounts. As for using Scheduled Transactions, I’d suggest setting it up to remind you and then you can fire/review/edit it when you want. Since it would remove money from Checking you probably don’t want it to auto-create unless you’ve also set up the pledge for auto-draft. You could alternatively set a Scheduled Transaction for just the virtual tracking part to auto-fire that you can edit/delete later if needed, and handle the actual payments separately. (as a reminder Scheduled Transaction, or using auto-fill or Duplicate) Regards, Adrien > On Jan 15, 2020 w3d15, at 10:53 AM, David Klassen > wrote: > > Thank you for your response. The mechanics was what I was trying to wrap > my head around. Because, yes, for tax purposes I want to show that I'm > paying a charity expense. But I also didn't want to have to do two things > every time I wrote a check but I couldn't see any way around it. I guess > you're just confirming that thought. > > As for the scheduled transaction methods, for "adjust date/amount" > would that include deleting it entirely? I guess, at some level I could > just let it go and then delete the entry once it's fired if I really did > miss that week. > -- > David R. Klassen ___ 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] Handling of Equity and Retained Earnings
Christian, Welcome to GnuCash! > On Jan 15, 2020 w3d15, at 9:56 AM, Christian Lynbech > wrote: > > Inspired by a recent discussion I would like to understand better how to > handle the Retained Earnings equity sub account, as I am new to both Gnucash > and accounting. > > In a world where books are closed at year end, I would understand Retained > Earnings as sort of the surplus of the year that is then added to the equity > so one starts the next year with a higher equity than the year before. > Correct. (well, hopefully ‘higher equity’. If you retained a loss, it would reduce your Equity) > When using Gnucash the recommended way of just keep going, there is not any > real need to distinguish the year end result, it just goes into the rolling > development of the accounts. Yes. > > However, at least here in Denmark, it is required for a company to produce a > statement of balance and result, how could one handle that? Just make a > report at year end that extracts the relevant numbers or simulate the closing > of the books by moving the appropriate amount to Retained Earnings and then > move it out again when the new year starts up? Always follow the advice of a local CPA who knows the laws and requirements of your jurisdiction. We can’t give accounting advice here. But we can help with how to implement accounting advice using GnuCash. For example, as you noted, your accountant may require a Balance Sheet as of the end of year. (where Retained Earnings is reported) The GnuCash Balance Sheet report should satisfy this requirement without needing to ‘close the books’. It will calculate Retained Earnings from the beginning of the book until the date of the report, just as if you had done so for the previous year, and then added that result to the other previous year’s results of closing. (in other words, just as if you maintained an actual Retained Earnings account under Equity) So there is no need for temporary or simulated closings. (but there is a Trial Balance report you should use just like the pen and paper days before running that final Balance Sheet, and should always be used prior to using the ‘close book’ procedure if you go that route.) If you decide to do a ’test run’ and close the books, reversing that is simply a matter of deleting the transactions put into Equity:Retained Earnings. (the expense one in particular will contain many, many splits, but just delete the whole thing) This will restore your Income & Expense accounts as if you had never closed them. Also note that your accountant or local jurisdiction may require reports in a certain form, to look a certain way, include only certain accounts, etc. This can mostly be accomplished from within GnuCash, but if you run into a roadblock, you can always export or copy/paste the resulting report into a spreadsheet and further refine from there. Finally, if you started your books with a balance forward in Retained Earnings (from a previous accounting app or from physical paper) then you might need to either continue closing the books manually, or else just combine the calculated Retained Earnings line on the Balance Sheet with the actual account called Retained Earnings on the report in a spreadsheet. (the actual account would in this case likely only contain the balance forward) It would be nice if GnuCash offered a means to declare an opening balance for this account and then combine it for you from then on. There might even be an RFE filed for this already. (I’ll have to check Bugzilla) Regards, Adrien ___ 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] Formatting the Register header?
Thank you for your response. The mechanics was what I was trying to wrap my head around. Because, yes, for tax purposes I want to show that I'm paying a charity expense. But I also didn't want to have to do two things every time I wrote a check but I couldn't see any way around it. I guess you're just confirming that thought. As for the scheduled transaction methods, for "adjust date/amount" would that include deleting it entirely? I guess, at some level I could just let it go and then delete the entry once it's fired if I really did miss that week. Date: Mon, 13 Jan 2020 14:13:29 -0600 > From: Adrien Monteleone > To: Gnucash Users > Subject: Re: [GNC] How to set up a pledge payment > Message-ID: <5c6e5ccd-c6bd-4841-b574-9118f4756...@lusfiber.net> > Content-Type: text/plain; charset=utf-8 > > You can create it as a liability account but just know that it isn?t a > legal one. You?ll also want to make sure in any official reports you > create, that you do not include it since it is just a pledge. > > This will require extra splits in your transaction to reduce the amount > promised. (as the real-world transaction will be between an asset and a > gift expense) Since the simplest starting transaction would be between the > liability and equity:opening balances, I?d just keep using those two each > time reversed for the amount actually donated. > > As for the mechanics, you can do the transactions manually which will more > than likely be autofilled or you can use the Duplicate Transaction feature > as needed. > > You could also create a scheduled transaction, but set it to not create > automatically, and check the box to review the transaction when you see it > fires (or just use it as a reminder) You can then edit the result before it > is committed to adjust date, amount, etc. > > Regards, > Adrien > > > On Jan 13, 2020 w3d13, at 1:49 PM, David Klassen > wrote: > > > > I was wondering if there were a way in gnucash to set up a pledge > payment. > > That is, let's say I have pledged to pay a charity, let's say $1300 this > > year, nominally $25/wk. But it is *not* an automatic recurring payment > > (sometimes I miss a week, sometimes I prepay an extra week, etc.). So > what > > I need is a way to do the manual entry on the payments but to have some > > kind of accounting telling me how much I have left to pay against my > annual > > pledge. > > > > My first thought was to create a liability account of the total amount > and > > pay that down, but it's not really the same as a loan... or is it in > terms > > of gnucash? > > > > Thank you for any suggestions you can give me. > > > > -- > > David R. Klassen > -- David R. Klassen Media, PA 19063 ___ 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] AR problems
> On Jan 15, 2020 w3d15, at 9:42 AM, Bruce Irving via gnucash-user > wrote: > > Thank you Adrien for your detailed reply. And my BP has dropped - I should > have waited another day before I made my "rant". My apologies. > >> Win10, GC 3.8, SQLLiteI am very disappointed - to the extent that I'm angry! >> I have tried all the reports in Business and Experimental and I could find >> none that give me a summary of my customers WITH a balance! Neither >> Customer Overview nor Customer Summary include the Balance and the Customer >> Report won't show which invoices are paid! > > The Receivables Aging Report shows all customers with a balance, as well as > the aging breakdowns of those balances. By default, only customers with a > balance are shown, but you can opt to show all customers if you like. Note, > there are problems with the standard version of this report. The beta version > in the experimental menu is better and will eventually be the standard. This > is probably the report you are looking for. > > The Customer Overview *does* show a balance, though maybe not by default. > There is a down arrow with a drop-down menu to the far right of the header. > From there you can select visible columns, where you will find ?balance? as > an option. > > The Customer Summary is not designed to show balances owed, but rather > profitability. However, it appears it doesn?t presently work properly. (and > some columns I can?t seem to figure out how to influence, that is, how does > the report calculate markup or expenses if those associated figures have no > place to be entered in the app?) > > Seeing which invoices are paid is a little different, and arguably the UI > could be better here. > > First, the new beta Customer Report has the option to show you the linked > ?documents?, that is, which payments apply to which invoices and do so in a > simple or detailed fashion. Think of this report as a ?statement of account? > where you can show more or less detail as desired. > > Second, the traditional and current official method for seeing which invoices > are paid/unpaid is to run a Find for all invoices (or by customer). There you > will see a Paid? checkbox column. You can?t mark them paid here, but you can > see if they are paid or not. You can also filter your search by if they are > paid or not, thus only giving you unpaid invoices, if you prefer. Sadly, this > result is not exportable nor can you copy/paste it somewhere else for > processing or tracking outside of GnuCash. (I?m pretty sure there is a bug > filed on this) > > Third, the Business > Customer > Invoices Due Reminder dialog will list all > invoices that have not been paid in full, along with their remaining > balances. I normally run GnuCash less than full width on a 1080p monitor and > I have enough room on the side for this reminder list to always be visible. > (as well as the AP equivalent, and my scheduled transaction up-next list) > > There are lots of ways to see the info you want, right out of the box. There > are others that might involve some creative searches and reporting based on > the AP or other Registers as well, but the above methods are much easier to > work with. > > Wow! When I get back to the office tomorrow, I'll dive into those reports > again. I guess my frustration was that there wasn't an edit report from the > toolbar. What I want to do is print statements for customers with a balance > due. As it stands, I have to look at each of 100+ customers one by one to > see if they have a balance, then print their statement. It’s the Receivables Aging Report you want then. When you get it configured with the options you like so it displays nicely, you’ll notice the total column amounts are all hyperlinks. Click the total of the customer for whom you want to print a statement and —voila! a Customer Report (aka Statement of Account) for that customer showing invoice and payment history along with aging and balance due. Note, this report (as all) have options for customization and you can pretty it up if you delve into report stylesheets. I leave my aging reports (AR & AP) open 24/7 in their own tabs along with GnuCash. I just reload them for a refresh as needed. It is a much saner workflow than having to run a blank Customer Report (statement) and then choose a customer in options. (when you get really adventurous, you can make a ‘dashboard’ using the multi-column report with your AR aging in one slot and the AP aging in another!) Now, as noted, the Aging reports have some problems. And they aren’t going to be fixed. Instead, new beta reports have been created from scratch. (In the experimental menu) Unfortunately, those versions hyper-link to the current standard Customer Report. That’s still usable, but the new corresponding beta version of that report allows for showing linked payments applied to each invoice. So if you want to use that newer version, t
[GNC] Handling of Equity and Retained Earnings
Inspired by a recent discussion I would like to understand better how to handle the Retained Earnings equity sub account, as I am new to both Gnucash and accounting. In a world where books are closed at year end, I would understand Retained Earnings as sort of the surplus of the year that is then added to the equity so one starts the next year with a higher equity than the year before. When using Gnucash the recommended way of just keep going, there is not any real need to distinguish the year end result, it just goes into the rolling development of the accounts. However, at least here in Denmark, it is required for a company to produce a statement of balance and result, how could one handle that? Just make a report at year end that extracts the relevant numbers or simulate the closing of the books by moving the appropriate amount to Retained Earnings and then move it out again when the new year starts up? /Christian ___ 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] AR problems
Thank you Adrien for your detailed reply. And my BP has dropped - I should have waited another day before I made my "rant". My apologies. > Win10, GC 3.8, SQLLiteI am very disappointed - to the extent that I'm angry! > I have tried all the reports in Business and Experimental and I could find > none that give me a summary of my customers WITH a balance! Neither Customer > Overview nor Customer Summary include the Balance and the Customer Report > won't show which invoices are paid! The Receivables Aging Report shows all customers with a balance, as well as the aging breakdowns of those balances. By default, only customers with a balance are shown, but you can opt to show all customers if you like. Note, there are problems with the standard version of this report. The beta version in the experimental menu is better and will eventually be the standard. This is probably the report you are looking for. The Customer Overview *does* show a balance, though maybe not by default. There is a down arrow with a drop-down menu to the far right of the header. From there you can select visible columns, where you will find ?balance? as an option. The Customer Summary is not designed to show balances owed, but rather profitability. However, it appears it doesn?t presently work properly. (and some columns I can?t seem to figure out how to influence, that is, how does the report calculate markup or expenses if those associated figures have no place to be entered in the app?) Seeing which invoices are paid is a little different, and arguably the UI could be better here. First, the new beta Customer Report has the option to show you the linked ?documents?, that is, which payments apply to which invoices and do so in a simple or detailed fashion. Think of this report as a ?statement of account? where you can show more or less detail as desired. Second, the traditional and current official method for seeing which invoices are paid/unpaid is to run a Find for all invoices (or by customer). There you will see a Paid? checkbox column. You can?t mark them paid here, but you can see if they are paid or not. You can also filter your search by if they are paid or not, thus only giving you unpaid invoices, if you prefer. Sadly, this result is not exportable nor can you copy/paste it somewhere else for processing or tracking outside of GnuCash. (I?m pretty sure there is a bug filed on this) Third, the Business > Customer > Invoices Due Reminder dialog will list all invoices that have not been paid in full, along with their remaining balances. I normally run GnuCash less than full width on a 1080p monitor and I have enough room on the side for this reminder list to always be visible. (as well as the AP equivalent, and my scheduled transaction up-next list) There are lots of ways to see the info you want, right out of the box. There are others that might involve some creative searches and reporting based on the AP or other Registers as well, but the above methods are much easier to work with. Wow! When I get back to the office tomorrow, I'll dive into those reports again. I guess my frustration was that there wasn't an edit report from the toolbar. What I want to do is print statements for customers with a balance due. As it stands, I have to look at each of 100+ customers one by one to see if they have a balance, then print their statement. > Also, I attempted to enter a Credit Memo and it would NOT allow me to > designate Cash on Hand. The message said something to the effect that the > account must be in the same currency. ALL of my accounts are USD!I finally > exported the AR Register and massaged it in a spreadsheet - a rather > cumbersome effort to get it massaged. I?m not exactly sure what went wrong here. I?d have to do a test. But make sure the customer you are issuing the credit note for is set for USD. (should be by default) I believe the warning is about the customer?s assigned currency has to match the account. I also have been using GNC since 2.6.? I have over 100 potential customers - all members of my Post (club). I imported the members last year from my member spreadsheet. I will order items for them and most pay me sometime after they receive them - even a year later. This one, however, paid by cash and the item is still in-transit - and that is a rare occurrence. It's my understanding that this credit will be applied to the invoice which will be made in the future. Payments either go into Cash on Hand or Checks on Hand. (They haven't been deposited yet.) Though I would ask, why do you want to issue a credit note linked to ?cash on hand?? Usually a credit note line item will be posted against an income/revenue account which will act as a reversing transaction. (a debit to income, rather than the normal credit) The credit note itself will post a credit to AR, which would reduce the customer?s AR balance. Maybe a walk-through of the part
Re: [GNC] storing password when using mysql backend
Op woensdag 15 januari 2020 05:15:07 CET schreef Fourhundred Thecat: > Hello, > > I am using Gnucash 3.4 with Mysql (MariaDB) backend. > > Every time I start Gnucash, I have to type in the mysql password. > > The way I see it, this seems more like a security theater than a real > security. Normally when Gnucash is using xml backend, files are stored > locally unencrypted. I see no reason why mysql backend should be any > different. Besides, security (encryption) should not be handles on > application level, but rather on System level (I have LUKS encrypted HDD) > > Can I store the password locally? (in a config file, plaitext is fine). > > Or, if this is not possible, where can I hard code it in the gnucash > sourcecode ? > > I already had to compile Gnucash from source (even though there exists a > Debian package for my distribution), so recompiling again would not be > difficult. > > I think I read somewhere that password can be stored in Gnome Keyring, > but I am not using Gnome Keyring. If you don't want to type the password every time, using Gnome Keyring is the only option provided on linux to store the password. It shouldn't hurt installing gnome keyring even if you only use it for gnucash. Regards, Geert ___ 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] General accounting question about Assets = Liabilities + Equity
Brandon, Continuing on what David noted... Income and Expenses are traditionally considered temporary accounts that are ‘closed’ to Equity at the end of an accounting period, generally, one year. Therefore, the expanded equation would be: Assets = Liabilities + (Income - Expenses) After the first period closing, you’d have: Assets = Liabilities + (Income - Expenses) + Retained Earnings Where ‘Retained Earnings’ are the result of previous periods where Income and Expenses were closed to Equity. (it is technically a sub-account of Equity. There can be other equity sub-accounts, but they generally come from Income, Expenses, or Retained Earnings.) With the advent of computers, the physical limitations of pen and paper no longer require the ‘closing of the books’ and thus Income and Expenses can roll over forever. If you need to do a traditional calculation of Retained Earnings, a report can handle that for you without a specific special account in your tree. (You can still perform this book closing with computers, but it is not necessary unless the software forces you to. GnuCash does not, and generally does not recommend it.) The signs that throw people off are because they are there when all of the terms are on one side of the equation. If you were to re-write it like so: Assets - Liabilities - Equity - Income + Expenses = 0 then you’ll see why Equity is listed as a negative. It isn’t a double negative, the sign doesn’t belong to the value itself. But it is stored that way, because it makes the equation simpler to write (in code) as all addition operations: Assets + (-Liabilities) + (-Equity) + (-Income) + Expenses = 0 Notice that all of the ‘positive’ terms are normally debit accounts. (a debit will increase them) And that the ’negative’ terms are all credit accounts. (a credit will increase them) It is this mess why some people recommend to turn on the feature to ‘reverse balance’ accounts for the credit accounts. (for display purposes only, not internal calculations) That way, Income looks positive, as does Equity. Liabilities will also look positive with that setting, which is easy to see the larger it is, the more you owe. (you already know it is a subtraction from net worth, because of its nature) This also allows for easy spotting of errors like reversed debit/credit entries. If an account has a negative balance, something is wrong. (unless it is a special ‘contra-balanced’ account, in which case a negative balance is a visual clue that the balance is ’normal’) Using positive values/signs for credit accounts also makes the traditional Accounting Equation make sense. The negative signs were only introduced to perform the "all addition" form of the equation. Regards, Adrien > On Jan 14, 2020 w3d14, at 11:38 AM, Brandon Captain wrote: > > Hello, > > I have a rather general accounting question in regards to the Assets = > Liabilities + Equity formula, and how it relates to the other GNUCash > default accounts like Income and expenses. Those accounts are neither > assets, liabilities, nor equity. So I'm not sure how to factor them in - > unless Income is an asset? Then why isn't it listed as a sub-account of > Assets? > > Take the following accounts for example: > > assets (debit) 209.01 > income (credit) 22975.27 > liabilities (credit) 1497.72 > expenses (debit) 5445.24 > equity (credit): -18818.74 > > (Equity breaks down as 3863.47 in contributions and -22682.21 in draws) > > If you add all the debits together, it comes out to 5654.25. Likewise, if > you add all the credits together, you get the same figure of 5654.25 (which > as I understand means that it balances). > > But assets = liabilities + equity would be ( 209.01 = 1497.72 + -18818.74 ) > which just... doesn't work. Not without the other accounts in the figure, > and not without reversing the signs since 1497.72 is actually -1497.72 in > reality, and so forth. > > I'd appreciate any explanation on this. I've Googled and researched a bit > but there's something I'm still not quite understanding. > > Thank you ___ 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] storing password when using mysql backend
If you don't want password protection on the db then you can set it to empty. Colin On Wed, 15 Jan 2020 at 04:18, Fourhundred Thecat <400the...@gmx.ch> wrote: > > Hello, > > I am using Gnucash 3.4 with Mysql (MariaDB) backend. > > Every time I start Gnucash, I have to type in the mysql password. > > The way I see it, this seems more like a security theater than a real > security. Normally when Gnucash is using xml backend, files are stored > locally unencrypted. I see no reason why mysql backend should be any > different. Besides, security (encryption) should not be handles on > application level, but rather on System level (I have LUKS encrypted HDD) > > Can I store the password locally? (in a config file, plaitext is fine). > > Or, if this is not possible, where can I hard code it in the gnucash > sourcecode ? > > I already had to compile Gnucash from source (even though there exists a > Debian package for my distribution), so recompiling again would not be > difficult. > > I think I read somewhere that password can be stored in Gnome Keyring, > but I am not using Gnome Keyring. > > thank you, > > > > > ___ > 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. ___ 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] General accounting question about Assets = Liabilities + Equity
Brandon, The Guide at section 2.2 says: "Assets - Liabilities = Equity + (Income - Expenses)" In your case: 209.01 - 1497.72 = -18818.74 + (22975.27 - 5445.24) Or: -1288.71 = -1288.71 Yay! HTH, David On Jan 15, 2020, 13:13, at 13:13, Brandon Captain wrote: >Hello, > >I have a rather general accounting question in regards to the Assets = >Liabilities + Equity formula, and how it relates to the other GNUCash >default accounts like Income and expenses. Those accounts are neither >assets, liabilities, nor equity. So I'm not sure how to factor them in >- >unless Income is an asset? Then why isn't it listed as a sub-account of >Assets? > >Take the following accounts for example: > >assets (debit) 209.01 >income (credit) 22975.27 >liabilities (credit) 1497.72 >expenses (debit) 5445.24 >equity (credit): -18818.74 > >(Equity breaks down as 3863.47 in contributions and -22682.21 in draws) > >If you add all the debits together, it comes out to 5654.25. Likewise, >if >you add all the credits together, you get the same figure of 5654.25 >(which >as I understand means that it balances). > >But assets = liabilities + equity would be ( 209.01 = 1497.72 + >-18818.74 ) >which just... doesn't work. Not without the other accounts in the >figure, >and not without reversing the signs since 1497.72 is actually -1497.72 >in >reality, and so forth. > >I'd appreciate any explanation on this. I've Googled and researched a >bit >but there's something I'm still not quite understanding. > >Thank you >___ >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. ___ 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.