Newly created invoice shown as paid:
In transactions report it appears as unpaid:
I believe, should be the same in both places.
Your first screen shot shows the status and balance due on a specific invoice. The second screen shot is of a drill-down report on some account or subaccount (you do not say which one). The balance figure in the second is a running balance of that account, not the balance due on any invoice. So why do you believe they should be the same? Just because an invoice has been paid does not mean some account has a zero balance. Where is the Transactions list from?
That is the problem - invoice was not paid, but it appears as it is paid under Sales Invoice tab.
Transaction list is taken from Customers tab, Accounts receivable column (show as unpaid):
If you do not trust that, here is a statement for this customer:
So, this invoice should not appear as paid, because it was not paid.
Also, just now noticed new thing - that customer and that amount does not appear at all in AR report:
I understand that it is cut out, but it is always the first customer due to it is name - there is no such customer and amount in the AR list. Changing report dates (to 28/03/2018 or later), does not affect report - customer does not appear and the amount is not on the list.
If you wish, in few hours I will be able produce clean example on test base.
1 Like
That means there was an unallocated credit for this customer, which Manager applies automatically to the next invoice created. Read about that here: Manager Guides.
As I said before, the Transactions drill-down does not reflect whether a specific invoice has been paid or not. It lists contributing transactions to an account balance. Based on the screen shot, it is correct.
If the invoice status is paid in full, it will not appear in the Aged Receivables report. The Aged Receivables report is created from sales invoices, not the Accounts receivable balance. So there is nothing wrong there.
The question you seem to be puzzled by is why this customer has an Accounts receivable balance when its invoice in the questioned amount is paid in full. To answer that, you must go to the Sales Invoices tab and click on the number or hyphen for that sales invoice under Balance due. You will see every transaction posted against the sales invoice with a running balance. Examine them to make sure all were correctly entered.
Also, are you using cash or accrual based accounting? If cash, understand that sorting out Accounts receivable problems is very difficult, because accounts receivable do not technically exist under cash basis accounting. Switch temporarily to accrual based account to sort out problems. No data will be lost and you can switch back at any time.
Not sure if I’m wrong, why is the starting balance is negative? I haven’t try test starting balance due to my business is new. so I don’t have to import opening balance. Currently, doing family’s company chart of account, a bit slow to set coa suitable using manager module system when it came from manually created coa where the approach is totally different.
I see that you do not get it.
There was no credit, please look at the customers statement I have attached, balance was 0 before creating invoice. I have made new invoice which appears as paid only in one place, everywhere else it is outstanding.
No, I “get it” completely. But you have not provided the information necessary to understand the results you think are wrong. And you did not answer my question about cash versus accrual based accounting.
For the third time, the “everywhere else” you refer to are not all locations that provide invoice status. Your Sales Invoices list and Aged Receivables report are in agreement. Your drill-down Transactions list from Accounts receivable for the customer is a separate thing and cannot be expected to show the status of an invoice. Yes, they are related, but not the same. The information you have not provided is the key to understanding the difference.
So, please, post the screen shot of the drill-down on the sales invoice itself and answer the question about the type of accounting you are using. Then we can make progress determining whether you have a problem.
I might figured it out. @Solnce is the rest of the any AR customer you did the same as the current one. as in Negative Starting Balance?
Try remove the starting balance and refund transaction. Create Journal entry for Account Receiveable > the same current customer (CR. Account Receiveable and DR. Dummy Bank account created manually in coa for receiving overpayment)
Then, use Bank Account tab and spend it on Account receiveable using Manager Module as usual. To record a refund.
Then check again whether that particular invoice the current AR customer is still in ‘paid in full’ status or back to normal ‘x days overdue’ or otherwise.
Then I will try to explain once again.
First of all, everything is ACCRUAL, nothing is cash.
Next thing, invoice is NEW and 0 credits before issue, it has to be UNPAID, such I expect it to appear everywhere.
Here is the invoice:
Here is the customers tab:
Here is the AR report:
Here is the customers transactions statement:
Here is the Sales invoice tab view:
I do hope it will be clear now.
If that is true and it is said to be normal workflow and not a bug, I will say bye to manager.
Well… did you try to test it? at least it does return it to normal? I don’t consider as normal practice, more like diagnosing.
Starting balance is work wonders for myself, since it does not show the debit credit of another account that I didn’t know of.
Thanks for the additional information, @Solnce. It does not, however, help resolve your issue. This is the third time I am asking you to click on the blue balance for invoice #3370 in the first business you showed. Post a screen shot of the list that appears. Posting things about other invoices in a different company does not help. Very likely, whatever you did in the first case you have continued to do in the second. Let’s stick with one example. Hopefully, that is a real one.
This is the same situation re-created with testing database - it is exactly the same.
Here is the “blue balance”
The same situation.
1 Like
Now we are getting somewhere. The problem is that you had a starting credit balance for the customer, just as I first guessed. This might be because you entered it directly for the customer for some earlier start date, or you might have set a start date for today. I’ll take your word that this example is exactly the same as your real-life situation. I know from your previous forum posts you did not start using Manager today. Therefore, you should not have a start date set for today. Unless you transferred to Manager from another accounting system for this test business (or your real business), you should not have a start date set at all.
As you have currently entered things, Manager took 6000.00 of the customer’s credit balance when sales invoice #2 was created, paying the invoice in full. Because the invoice is fully paid, it does not appear in the Aged Receivables report.
Go to the Reports tab and click on Starting Balances. Post a screen shot of the result. If there is any figure on the Accounts receivable line, click on it and post a screen shot of that, too. Finally, click on Edit for customer AAA1 and show the entry screen.
1 Like
Please post a screen shot of the Edit screen for the refund payment on 2018-01-31.
Thank you. What was the source of the 10,000 credit? In other words, why did the business, test-1, owe customer AAA1 10,000?
What I’m trying to understand is why, at the moment sales invoice #2 was created, the program thought you still owed AAA1 at least 6,000. (It may have thought you owed more, but only needed 6,000 to pay the invoice.)
One thing that sticks out is that you have changing numbers of bank transactions, customers, and journal entries. So your screen shots do not all apply to the same moment in time and financial position. That makes it difficult to draw conclusions. Can I ask you to stop making entries until we can figure this out?
Please post screen shots of the Bank Transactions and Journal Entries tab listings.
1 Like
