Why does my accounts receivable have a balance when i run my reports on a cash basis
Julian Sellings
Member Posts: 5
For some reason, my accounts receivable account has a debit balance of $39000 when I run the reports on a cash basis. It seems tax invoices are posting to this account and I acnnot work out why.
0
Comments
Hi Julian,
The AR and AP balances on a Cash Balance Sheet are always wrong. You should never run a Cash Balance Sheet due to this reason.
Just run it on Accrual and if correct, don't worry!
Kind regards,
Sally McIntosh ([email protected])
Hello,
I also believe that QuickBooks is behaving in an unexpected way in regards to “Cash Basis” reports vs “Accrual Basis”. In my case, the issue happens when refunding money to customers.
The answers given in this forum just don’t make sense to me. I wrote to Reckon and they were no help either. They just said “Ask your Accountant”. Bit wrong if you ask me as it is Reckon’s Software, surely they know why it behaves in the way that it does?Here is my issue and any assistance in understanding is appreciated. I am having trouble understanding why there is there an amount under “Accounts Receivable” when I run my Balance Sheet (Cash Basis) and yet the Balance Sheet (Accrual basis) has NO money owing to us.
I know that definitely no customers owe us any money and yet, on the balance Sheet, there is a large amount of money growing year by year.
In our situation;
· We Direct Debit money from many, (over 100), customers’ accounts once per fortnight using an uploaded ABA file to our Bank.
· The single Lump sum $ amount is direct deposited in to our Bank Account by the Bank. This is recorded in QuickBooks as a single “Cash Sale”
· A few days later 3 or 4 of the Direct Debits can ‘fail’ due to insufficient funds in the customers’ accounts.
· When this happens a “lump Sum” debit from our bank Account is taken by the bank directly from our bank Account.
· This lump sum can consist of 3 or 4 individual customers all rolled in to the one $ amount.
The way that we handle a Failed Direct Debit is as follows:1. We DD all customers, (over 100 of them), for say $30,000
2. We enter in to Quick Book the full $30,000 as a single “Cash Sale” (even though there are over 100 customers) and this amount is deposited to our account by Westpac
3. A few days later (say $600) is withdrawn by Westpac directly from our Bank account as some Customers DD failed
4. We then reverse the individual Customer DD by giving a ‘Refund’. This is a feature of QuickBooks and the accounts all now balance.
5. We then accept the “Write Refund” cheque Prompt and our Bank account now balances perfectly.
6. It appears that this process creates the abovementioned “Accounts Receivable” amount Yet we have no actual money owed to us as at a later date we take the failed DD amount and we then have no customers owing any money to us.
Thanks for asking the Reckon Community and thanks to everyone who has contributed to this thread.
The A/R and A/P appearing on a cash-basis Balance Sheet is an unfortunate by-product of inventory, cash-basis reporting, double entry bookkeeping and QuickBooks holding data on an accrual basis.
The issue has been around since Day 1 of QuickBooks and if you google the issue you will see hundreds of posts about it over the years.
Let me try to explain it.
When you purchase inventory (inventory parts) it is stored in the Balance Sheet account Inventory Assets. When this inventory is sold, the cost of the items are transferred to the Profit & Loss account COGS.
When you call up a report on a cash basis, Accounts Business has to modify it - check that the invoice/bill has been paid and make a couple of other changes needed for the report. That's why cash basis reports take so much longer to produce than accrual basis reports.
Now if a Sale/Purchase has not been paid then it is not included in the cash-basis report. However the inventory associated with these transactions have already moved out/into the Inventory Account and we cannot simply pretend the transaction did not happen as the inventory has to be accounted for.
Although the Sales/Purchase side of the transaction can be "forgotten", according to the needs of Double Entry Bookkeeping, the COGS has to go somewhere to balance the movement out of the Inventory Asset account. The designers, for better or for worse, decided to leave that COGS value into the A/R and A/P account.
So, if your file contains no errors, then the value of the A/R on a cash-basis Balance Sheet should equal the value of Inventory sold (at its average cost) on Sales not yet paid. Similarly for A/P.
Run the same report on an accrual basis and there should be no discrpancies.
Hope this explains what's going on.
BTW, I thought Australian Accounting Standards demand that reports be done on an accrual basis. Is that still the case? Are there any exceptions?
regards,
John
Thanks for asking the Reckon Community.
If there is no sensible answer then rebuild your file. Examine the QBWin.log files for the error. Verify the file - any errors found? And run the reports again.
Otherwise, some further information on the way you process this transaction will be helpful. Sorry if these questions sound somewhat simple but often the problem lies in the fine detail.
You said that you record the DD as a Cash Sale. I presume you are using the form Sales Receipt to the customer "Cash Sales". Is this correct?
What item are you using on the sale? Is it an Inventory Party type item?
Do you sell inventory parts to other clients or not by DD?
Do you ever record this DD against a customer account and how do you do it?
When a particular customer payment bounces you give a REfund to that customer or to "Cash Sales"? And then select the Write Cheque option.
How much is the Accounts Receivable amount that should not be there? The DD amount? the Bounced amount? DD minus Bounced amount? something else?
I hope the "Brains Trust" here can get an answer for you.
regards,
John
We are a child care Centre. Every fortnight we Bulk DD over 100 families their child care fees.
This is recorded as one "Cash Sale" and appears on our bank statement as one sale as well. (ABA File Upload).
A few days later a few of the DD may fail and the bank credits back to our account a single sum that represents the several transactions in one $ amount.
I then follow the normal refund process as I described in my earlier post.
This is all very normal and I am advised the correct way to do it.
As I said, Accrual basis reporting the amounts under receivable is $0 but under Cash Basis it is slowly increasing over time.
I suppose I should stop using Cash basis reporting but I understand Cash better than Accruals.
Hope that helps.
Robin
Hi Robin,
No a refund cheque to a customer is correct to use Accounts Receivable.
Kind regards,
Sally McIntosh ([email protected])
Please check which account the item that you use in the adjustment note is linked to - your answer may lie there
From your posts, I gather that you use a separate program to manage the child care fees and the invoicing and management of the bounced DDs.
Let me just reflect on your process; the bounced DDs are processed as if you are refunding an overpayment to the customer, when in reality the customer still owes you money...
Although your process achieves the right result, I think the means are so misleading they do not justify the end.
An alternative way of doing this would be as a journal entry as follows,
This method also steers clear of Accounts Receivable.
Graham Boast
Reckon Accredited Consultant
[email protected]
www.reckonhelp.com.au/remotesupport.htm