UK AR reconciliation

Joined
Aug 26, 2023
Messages
1
Reaction score
0
Country
United Kingdom
Hi - im trying to reconcile my cash receipts per the bank, looking at income booked in the month per the PL adding VAT, movement in AR, movement in deferred income - im getting a difference - all my pl invoices have gone through AR, and deferred journals all to tie into the PL, VAT is all correct...so im. not sure what Im missing - any thoughts? thank you!
 

kirby

VIP Member
Joined
May 12, 2011
Messages
2,472
Reaction score
338
Country
United States
Instead of reconciling a whole month at a time, do a day by day recon. Hopefully the difference will be easier to find with a smaller amount of data.
 
Joined
Oct 17, 2023
Messages
7
Reaction score
0
Country
Bangladesh
Hi - im trying to reconcile my cash receipts per the bank, looking at income booked in the month per the PL adding VAT, movement in AR, movement in deferred income - im getting a difference - all my pl invoices have gone through AR, and deferred journals all to tie into the PL, VAT is all correct...so im. not sure what Im missing - any thoughts? thank you!
You could recorded any income as expense or expense as income. I mean do you have any person/company that is both your customer and supplier? kindly checked again. If you need help to solve this problem , i can help you. thanks
 
Joined
Jun 4, 2025
Messages
1
Reaction score
0
Country
United Kingdom
Hi - im trying to reconcile my cash receipts per the bank, looking at income booked in the month per the PL adding VAT, movement in AR, movement in deferred income - im getting a difference - all my pl invoices have gone through AR, and deferred journals all to tie into the PL, VAT is all correct...so im. not sure what Im missing - any thoughts? thank you!

Ah I’ve been there....honestly, it’s usually some timing thing messing with the match. Even if AR, VAT, and deferred all look right, sometimes the bank shows money a bit earlier/later than the P&L, or there’s random stuff like refunds, interest, or someone paying without an invoice. What helped me was using Finexer to pull the bank data in real-time, it flagged a couple of things I would’ve totally missed otherwise. Might be worth a try, or even just exporting the bank lines and tagging them manually once.....usually one oddball transaction clears it up.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
11,893
Messages
28,091
Members
23,390
Latest member
Intellgus

Latest Threads

Top