How do I remove duplicated credit card transactions?

Problem reported by Paul Barnes 9 years ago

Just trying to get my year end accounts ready, and notice that my company credit card balance on Clearbooks doesn't reconcile to my bank records.

The reason is that there are some duplicated transactions in there. So I have some duplicated PAY bills created, and these are marked as paid by the credit card. So I'm thinking I need to remove the duplicated bills - but they are part of a previous VAT return so I could raise a credit against them?

But if I do that it doesn't fix the bank balance on the credit card account. I somehow need to delete the payment and I get the following message: "PAY000180 has been included on a VAT return and cannot be deleted. The Bill you want to void has a payment allocated against it. Please either "Delete Payment" to delete just the payment or "Delete All" which will delete both the payment and the bill" But then there isn't an option available as a button to press to Delete Payment.

It's only £89.40 covering 8 transactions but it means that my account balance doesn't reconcile back.

Solved
Write reply4

4 Replies

Hi Paul

Do a money in transaction:

file

file

Then explain it as a refund:

file

You could either do 8 individual transactions or 1 single one to cover the £89.40 [if they're all to the same 'account'.

The credit card should then balance and the VAT will be corrected via the next return.

9 years ago

Many thanks again Kevin - it worked a treat. The Money In and Out functions sometimes baffle me!

Is there a similarly easy way for another old problem I have re a Euro COntra Account I set up.

There was an 825 Euro amount in a bill that the customer contra'd against an invoice payment to me.

Somehow 1 sits at GBP602.75 and the other GBP573.58, so the bank balance for this account shows -29.17, but in Euro terms it should be zero.

What's the best method to zap the 29.17 balance and return it to a zero balance?

The extract below is from a csv export of the account and hopefully shows the 2 transactions.

description entity_id accounting_date ptype amount 825€ contra for bill 341 29 01-Sep-15 BP -602.75 Contra payment inv 186 against bill 341 825€ 29 01-Sep-15 BR 573.58

9 years ago

Just do a money in for the 29.17 in the name of the customer/supplier with the account either set as FX differences or other income (excluded from the VAT return) - doesn't hugely matter which.

9 years ago

Reply to this problem

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are

Apps

Company

Social