Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
i'm transferring my mum,s books for last year to quickbooks and to say its all in a muddle is an understatement. I would like to know how to match bank deposit to multiple l invoices when deposit is less than invoices total.
example.
mr k smith invoice total £500
mrs j hill invoice total £600
mr p scott invoice total £800
invoice totals £1900
but bank deposit was only £1700 (mum kept cash on hand)
when i created invoices i did them as cash into undeposited funds, when i came to match bank transaction to invoices i can add mr k smith and mrs j hill easily but if i add mr p scott it goes over by £200. i originally thought to fix this was to add additional deposit (at the bottom of page) payee mr p scott amount -£200 which brings it back in line but don't know if that's the correct way to do it.
Solved! Go to Solution.
Hi marionsxgal,
Thank you for your query!
As all the invoices where paid in full by the customers but 200 was kept cash on hand the best way to record this is to receive full payment on all the 3 invoices but instead of receiving it to the bank receive it to the undeposited funds chart of account(it will be an option on the dropdown under the bank account options on the receive payment of the invoice or you can create the undeposited funds account it if it is not already there) So you were correct in recorded them as paid to undeposited funds. You just have to record them all as paid in full to undeposited funds and then deposit most of it to the bank account and do a separate deposit to the petty cash account.
Please find the steps below:
Then go back into bank deposit. If there is a chart of account set up for petty cash select that and deposit the remaining balance to the petty cash account. If there is not one set up for petty cash it is worth setting one up so you can record what the petty cash is used for expense wise etc. The save the bank deposit for the 200 that will then show in the petty cash account.
Let me know if you have any queries.
Hi marionsxgal,
Thank you for your query!
As all the invoices where paid in full by the customers but 200 was kept cash on hand the best way to record this is to receive full payment on all the 3 invoices but instead of receiving it to the bank receive it to the undeposited funds chart of account(it will be an option on the dropdown under the bank account options on the receive payment of the invoice or you can create the undeposited funds account it if it is not already there) So you were correct in recorded them as paid to undeposited funds. You just have to record them all as paid in full to undeposited funds and then deposit most of it to the bank account and do a separate deposit to the petty cash account.
Please find the steps below:
Then go back into bank deposit. If there is a chart of account set up for petty cash select that and deposit the remaining balance to the petty cash account. If there is not one set up for petty cash it is worth setting one up so you can record what the petty cash is used for expense wise etc. The save the bank deposit for the 200 that will then show in the petty cash account.
Let me know if you have any queries.
Hi, I have the same problem except that my payments do not show up in the list of available payment to match to the deposit. I have one invoice for $500 and a refund to another customer for $200. I know how to deal with the refund, but why is the $500 customer not on the list. If I go to a larger deposit $2000 he is on the list of payment to match to.
Thanks,
Mary Ann
Hello there, Mary Ann.
There are instances that QuickBooks Online is unable to find or match the correct one. So we'll have to manually find the matching transaction.
Just follow these steps:
I've got you an article for future reference: Add and match downloaded banking transactions.
Reach out to us if you have other concerns. Have a great day!
@marionsxgal wrote:
mum kept cash on hand
You have to still credit the customer with what she kept on hand
Hi I am new to QBO. I have synced my bank accounts and deleted everything that came over before April 1st this year. So there are several transactions to explain. Some payments are from recurring customers. I get that i can make an invoice. I did this but how do i explain these invoices as already paid, because they are showing up as awaiting payment. Most of the payments are made by bank transfer. I am not using the 'take payment option' There is one customer who has sent several payments over for 25.00. I have made 3 invoices to explain this but one them is asking for 0.45p! I dont understand as i havent created an invoice for this amount! Please help
Hello Jane Foulger,
Welcome to the Community page,
When you click into the invoice, you will see an option call receive payment on the right-hand side, click that fill in the information and save. once you have clicked save and close this will show that that invoice has been paid and you'll be able to match it in the banking page, as long as the date, amount and account is the same it will find the match for you.
Hi,
I think I know your exact issue and how to fix it.
-Go to banking and go to "reviewed". Please find the payment in question and "undo" it so that it goes back into your "for review section". Please write down on a piece of paper/remember the date of that payment. Leave that as is and we will come back to it.
-Go to your invoices section and find the invoice. Then click the downwards arrow on the right next to the word "print" and click "view/edit"
-On the right it says "paid status", under this can you see blue writing that says "1 payment" and then in black writing "made on .....", please click the blue writing and then click the blue date.
-Here the payment you received in your bank account comes up, for some unknown reason, I think it may be a glitch, but it says on the left under "payment date" the wrong date to when it actually was deposited. Now that date I asked you to write down before, put in that date instead. Click save and close.
-Go back to your "for review" tab and the payment now should have a match. Click "match".
-Go back into your "income section" on your report and it now should be fixed and there should only be one payment there for that amount.
Hope this helps!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.