Question asked by Chris Swadling 10 years ago
I have imported by bank statement and am trying to explain all references within. The issue that I have is a customer has paid an invoice on two separate occasions. Does anyone know how i can explain this as i have paid the invoice and i now have a second payment in my bank statement with no invoice as already paid. Any ideas would be appreciated
Hello Chris and Kevin,
There is a way to show a payment on account via a bank import.
Please can you navigate to Settings > Codes > All. You will get your chart of accounts where you will need to tick "show in sales" for TRADE DEBTORS and then tick "show in purchases" for TRADE CREDITORS.
Navigate to your bank explanation screen. You will get the screen below for sales on account.
This is where you will choose trade debtors for sales and then trade creditors for bills.
The amounts will appear under Money > Bank Accounts > Unallocated Cash.
Hopefully this helps.
Vanish
Best answerHi Chris
Are you planning on sending the funds straight back to the client or leaving them on account?
i plan to leave them on account and use on future invoices
Ok, it's not something you can do directly from the bank statement import unfortunately so make a note of the details then delete it off.
Then go to Sales > Money In and complete the necessary details.
Hello Chris and Kevin,
There is a way to show a payment on account via a bank import.
Please can you navigate to Settings > Codes > All. You will get your chart of accounts where you will need to tick "show in sales" for TRADE DEBTORS and then tick "show in purchases" for TRADE CREDITORS.
Navigate to your bank explanation screen. You will get the screen below for sales on account.
This is where you will choose trade debtors for sales and then trade creditors for bills.
The amounts will appear under Money > Bank Accounts > Unallocated Cash.
Hopefully this helps.
Vanish
Best answerMost helpful Vanish, thanks.
thank you this has been useful. I have had a quick look at 'unallocated cash' which now shows my money but it says that there are no unpaid invoices where the customer has several. any ideas?
Do I have to allocate this unallocated cash against a credit note to appear for the customer and therefore for me to use?
I thought you wanted to leave it on account to use against future invoices? If so, you won't allocate it until those invoices have been created.
If however you want to allocate it against invoices that already exist you can obviously do so. Money > Unallocated cash > Select the payment ID > Allocate.
I have raised new invoices today that the customer could use the money against if they choose. If i go to allocated cash> select payment ID > Allocate it says that there are no invoices??
Go to Money > Unallocated cash and check the entity name.
Then go to Sales > Unpaid and check the invoice you did today a) is for the same entity/client and b) hasn't already been paid by accident.
Hello Chris and Kevin,
You can go to the invoice and then click on the Allocate button on the top right. This will show the unallocated cash as well. This will be another way to allocate the payment received. This will essentially take you to the same page as what Kevin has mentioned.
Vanish
there is no entity name - how would i name it please? many thanks
Chris
I'm surprised it's let you assign a payment on account without attaching it to an entity/client - i've just tried and couldn't do it.
Without me seeing what's going on in there it's hard for me to comment too much further. Vanish may well pick this up for you but if not you're welcome to call me on 02476 980440 and i'll see if I can quickly get to the bottom of it for you.
Hello Chris,
I have checked your account and you are correct.
Please go to Money > Banks Accounts > Unallocated Cash and click on the payment ID link. You will be able to edit the payment information to the entity of your choice on the edit form.
You can contact us by going to the Need Help? link when you are signed into Clear Books. You will be able to call us or use a support chat if you wish.
You will be able to email us at contact support if you want to have a ticket.
Vanish
many thanks for both of your help. All sorted and showing/not showing where needed.
You must 