Re: [GNC] customers and vendors opening balances
The balancing account for all your opening balances should be an Equity:Opening Balances account. You can create sub-accounts of this if you need to separate different classes of opening balances. The customer invoices would have entries of the form: Assets:Accounts Receivable Dr Equity:Opening Balances:A/R Cr (instead of the income account) and for vendors Liabilities:Accounts PayableCr Equity:Opening Balances:A/P Dr (instead of an expense account) When your customer pays zzz off their outstanding invoice you would pay it against the invoice raised Open the invoice used above above to create the opening balances and use then use the Pay option and it should create the following entries or equivalent: Assets:Bank:Checking Dr zzz Assets:Accounts Receivable Cr You should have no need to raise a credit note to record the payment of the outstanding invoice. Payments can be partial and not completely pay off the invoice. 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.
[GNC] customers and vendors opening balances
hi all i have gnucash 3.5 and its beautiful :D i have searched all over for an answer relating to previous year balances, could you please confirm if i am on the right track. firstly, a friend of mine is an accountant and we run a business. i have his financials from excel and i am basically seeing if i can achieve the same yearly financials within gnucash (1 March 2018 - 28 February 2019). Do you think this is a good alternative way to learn? secondly, i have read that any opening/previous balances from last year with customers or vendors should be entered through an invoice. so i enter the exact customers invoice (dated 27 feb 2018) from the last month of the previous financial year, and it has lots of products on the invoice. i post and i then have to do a credit note for the customer to match the exact balance owing from prev year as the customer pays random amounts. the credit note now wants me to choose an income account, but which one? i am unsure which product i am crediting because the amount is random and in theory no product is returned. so should i create and use a new income account and call it income:previous balance? example: on my bookkeeping software the customer owes $700 on 28 Feb 2018 (previous financial year). -customer was invoiced for goods of $1000 on 27feb 2018. i do an invoice for $1000 in gnucash. -but customer had a credit of $300 in jan 2018. so i do credit note for $300 in gnucash. i am now bringing forward the correct amount of $700 in gnucash. here is the next confusing part. i have created my accounting period start and end dates and filtered/chosen my year dates for all the accounts but my income accounts always combine with last years opening balance. also, on eugile balance sheet, it also shows last years opening balance combined with current year. i have tried to select different sheet dates, i have tried to select end of this year, end of previous year, end of accounting period but it never shows the current year amount. i really wish we could select a start and end date on this report. however, on the income statement report, income accounts reflect the true amount like my accountant has it on excel. so is this correct? is eugile balance sheet and income statement meant to show different figures just because of a previous opening income balance from last year? its the same for my expenses too, both reports show a different amount. thirdly, in my checking account, if i assign a transaction as a payment, gnucash automatically changes the description of the bank statement to a customer/vendor name. the descriptions from my bank statements now don't match with gnucash transactions, is this okay or will it confuse an accountant? thanks a lot -- 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] Reconcile bug
Definitely. Steve On Fri, Jun 14, 2019, at 11:49 AM, Colin Law wrote: > Are you sure you are running 3.5? I seem to remember such a bug in one > of the early 3.x releases. > > Colin > > On Fri, 14 Jun 2019 at 13:52, Stephen C. Camidge wrote: > > > > Using version 3.5 on Mac OS, I find the following: > > > > Reconcile a bank or credit card, but at the end, hit postpone. I do this so > > that I can keep track of what is currently reconciled. I do the full > > reconcile at monthend. > > > > Save the file. > > > > Close the file. > > > > Re-open the file. > > > > Reconcile the bank or credit card. The previously partially reconciled > > items are no longer partially reconciled. > > > > This happens most of the time - sometimes it stays partially reconciled. To > > me, it should stay partially reconciled. > > > > Is this a known feature? > > > > ___ > > 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] Reconcile bug
Are you sure you are running 3.5? I seem to remember such a bug in one of the early 3.x releases. Colin On Fri, 14 Jun 2019 at 13:52, Stephen C. Camidge wrote: > > Using version 3.5 on Mac OS, I find the following: > > Reconcile a bank or credit card, but at the end, hit postpone. I do this so > that I can keep track of what is currently reconciled. I do the full > reconcile at monthend. > > Save the file. > > Close the file. > > Re-open the file. > > Reconcile the bank or credit card. The previously partially reconciled items > are no longer partially reconciled. > > This happens most of the time - sometimes it stays partially reconciled. To > me, it should stay partially reconciled. > > Is this a known feature? > > ___ > 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] Reconcile bug
Sounds like a bug. I shouldn’t think the method used to clear them should change the fact that they show up checked or not. Regards, Adrien > On Jun 14, 2019, at 8:45 AM, Stephen C. Camidge wrote: > > The transactions retain the 'c' but are not always checked off when I resume > the reconciliation vis the reconcile window. > > > > On Fri, Jun 14, 2019, at 9:41 AM, Adrien Monteleone wrote: >> Not sure, but ‘partially reconciled’ is simply ‘cleared’ as you can >> change the individual transactions in the register to ‘c’ without using >> the reconciliation procedure. When you start that process, all >> transactions marked ‘c’ will be checked off for you. >> >> That status *should* be saved however, I would think, even if they >> aren’t checked off manually. (that is, via the reconcile window) >> >> Regards, >> Adrien >> >>> On Jun 14, 2019, at 7:50 AM, Stephen C. Camidge >>> wrote: >>> >>> Using version 3.5 on Mac OS, I find the following: >>> >>> Reconcile a bank or credit card, but at the end, hit postpone. I do this so >>> that I can keep track of what is currently reconciled. I do the full >>> reconcile at monthend. >>> >>> Save the file. >>> >>> Close the file. >>> >>> Re-open the file. >>> >>> Reconcile the bank or credit card. The previously partially reconciled >>> items are no longer partially reconciled. >>> >>> This happens most of the time - sometimes it stays partially reconciled. To >>> me, it should stay partially reconciled. >>> >>> Is this a known feature? >> ___ 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] Reconcile bug
The transactions retain the 'c' but are not always checked off when I resume the reconciliation vis the reconcile window. On Fri, Jun 14, 2019, at 9:41 AM, Adrien Monteleone wrote: > Not sure, but ‘partially reconciled’ is simply ‘cleared’ as you can > change the individual transactions in the register to ‘c’ without using > the reconciliation procedure. When you start that process, all > transactions marked ‘c’ will be checked off for you. > > That status *should* be saved however, I would think, even if they > aren’t checked off manually. (that is, via the reconcile window) > > Regards, > Adrien > > > On Jun 14, 2019, at 7:50 AM, Stephen C. Camidge > > wrote: > > > > Using version 3.5 on Mac OS, I find the following: > > > > Reconcile a bank or credit card, but at the end, hit postpone. I do this so > > that I can keep track of what is currently reconciled. I do the full > > reconcile at monthend. > > > > Save the file. > > > > Close the file. > > > > Re-open the file. > > > > Reconcile the bank or credit card. The previously partially reconciled > > items are no longer partially reconciled. > > > > This happens most of the time - sometimes it stays partially reconciled. To > > me, it should stay partially reconciled. > > > > Is this a known feature? > > > ___ > 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] Reconcile bug
Not sure, but ‘partially reconciled’ is simply ‘cleared’ as you can change the individual transactions in the register to ‘c’ without using the reconciliation procedure. When you start that process, all transactions marked ‘c’ will be checked off for you. That status *should* be saved however, I would think, even if they aren’t checked off manually. (that is, via the reconcile window) Regards, Adrien > On Jun 14, 2019, at 7:50 AM, Stephen C. Camidge wrote: > > Using version 3.5 on Mac OS, I find the following: > > Reconcile a bank or credit card, but at the end, hit postpone. I do this so > that I can keep track of what is currently reconciled. I do the full > reconcile at monthend. > > Save the file. > > Close the file. > > Re-open the file. > > Reconcile the bank or credit card. The previously partially reconciled items > are no longer partially reconciled. > > This happens most of the time - sometimes it stays partially reconciled. To > me, it should stay partially reconciled. > > Is this a known feature? ___ 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] Future transactions
Thanks David, David Carlson-4 wrote > I believe one important take-away from this thread is that there are many > ways to use scheduled transaction s and there is no one best way that > works > for all users. > > If a developer were to tackle some of the bugs and feature requests in > this > area it would be important to avoid "breaking" one use to optimize > another. > > David Carlson > ___ I agree with you on the importance of avoiding the breakage of one useful feature to optimise another, but evolutionary improvements are only made when a need is flagged up and deemed worthy of implementation. Sometimes, (often) dismantling followed by reassembly can achieve significant improvements, which is the way I assume GnuCash has evolved. Thanks to all developers for the efforts involved. Alan -- 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.