How Can I reconcile the VAT ledgers for YE accounts when in Cash Accounting, using Sage?

Question

I have several customers who run VAT Cash Accounting. This means that at YE, they will have amounts left over in the VAT ledgers, which I then need to reconcile. To date, I'm doing this manually, by exporting the creditors and debtors ledgers to Xcel, and then calculating the VAT content of the outstanding items. 
 Is there any way to have Sage do this work for me? Any reports I can print out that will provide this information, and save me time? 
 Thanks. 
 Lisa

Paul Morgan · Answer

Ok, thanks Lisa. 
 You can run the Nominal Activity report on your VAT liability (default 2202), Sales Tax Control Account (default 2201) and Purchase Tax Control Account (default 2200) nominal codes. You can run this report from Nominal codes > Reports > Nominal activity . 
 If this has answered your question, please click on the &lsquo;This helped me&rsquo; link below.

Lisa De Haas · Answer

Hi Ken, that was an interesting idea. I've done this, and ran some reports. Unfortunately I came across some anomalies where invoices were part paid, and the invoice is still showing the N - it seems that it's not flagged as Paid, until it's fully paid. So it still required manual checking and reconciling. What gets me is that surely there are more companies who run their VAT on a cash-accounting basis, and surely they must run into the same problem? Perhaps someone can look into this now?

Sage 50 Accounts

How Can I reconcile the VAT ledgers for YE accounts when in Cash Accounting, using Sage?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING