Why does the above sales invoice (right at the very top) NOT appear in here?
I’ve been trying to guess at and arrive at solutions that work and make the balances “adjust”, but I can’t wrap my head around it, and it’s not adjusting.
Those receipts into the cash at bank account adjust the A/R-ML, but the sale invoice (creating part of the sale to which that receipt relates) does not.
edit: added A/R payment of 2017-02-02 to show it’s on the same A/R account
This is leading to errors elsewhere in manager and I am not confident of the data I am sending my accountant.
I am registered for GST on a cash basis as per my accountants recommendations. It is not an option to change to accrual method of accounting. Please, let us not enter into a discussion or debate on which it should be.
For a few periods I recorded eatnow and menulog payments on a sales invoice by themselves with no mention to other totals of the day. Those days (that have “Sales-MLEN” and “A/R-ML” only—more correctly, where the balance at the end of the invoice is zero) are the values that are being summarised incorrectly.
If There is just 1 cent attached to the invoice and a payment is made, it clears and works. A real PITA since I did it this way as a result of a lengthy discussion in these forums about how best to accommodate my needs. That’s ok, I don’t mind that, I will fix that problem.
That’s a big call, and yours to make obviously. But it would appear to me (a non accountant) an invoice, totalling to zero, would still need to have the underlying accounts reconciled.
Just a observation. Based on the first screenshot, I wouldn’t use a negative qty, I would enter the A/R value as a negative value: -48.76.
Now that won’t fix the zero sales invoice under cash basis, but it removes a complication.
Also, why cash accounting may be best for the business, changing to accrual accounting is probably the quickest way to resolve the issue as all transactions will then record correctly.
I suspect the impact will be minimal as A/R and A/P balances would be less than $5k.
Also, reconciling will be a dream as you have no hidden transactions.
No man, there is a HUGE list of restrictions AS-IS and the development team is not so keen on looking after niche user needs.
Zero valued documents provide one work around for many unnecessary restrictions. One of these restrictions is the Document Referencing System, specifically, in open document statements of account (named unpaid invoices) I cannot show open on-account-receipts, Dr/Cr notes or Journals, or anything really not labelled as invoice.
Another restriction is the allocation of customers and suppliers to a SINGLE control account (a practice that is outdated if you ask me, separate dimension are the way to go now) which result in having to maintain multiple accounts for a single counterparty if your relationship is complex. Which cause giving out wrong net receivable/payable figures because of missing out an account or two.
My work around all of these unnecessary restrictions is creating dummy-0-valued invoices. I cannot tell my Clients no what you want is wrong because Manager team says so. They will just say: “Use something else.”
I really like Manager despite all of its unnessary restrictions but adding more restrictions is not the way to go, what you believe may seem right to you but so does what other people think. You should always go with the method that gives the end user the option instead of forcing a workflow which may not suit the users need.
If you want to keep your current restrictions, leave us something to work with, 0-valued documents incl. invoices are a must.
