Yet - if I'm reading your first post correctly - there are cash payments, and the VAT return itself is correct, so does include them in the figures?

I can't say I've ever encountered that before and, offhand, I can't think of any option within Sage that would lead to that happening. (You can configure tax codes as to whether they are included in the return - but a code that is set that way is excluded from the return figures as well as the detailed reports; it's how T9 is set up by default, for example).

"I can work it out easily using the audit trail in VAT rec order.."

You can also get a breakdown of the transactions from the VAT return itself: Double click on the VAT return to get the basic return up, then click on any of the values to open up a VAT breakdown summary for that box. That window has an option to export to Excel* but (not having Excel I don't know how detailed that is - I suspect it's just that summary) you can then double click on any of the figures to call up a list of transactions, which can itself then be sent to Excel or printed.

Looking at it now, it doesn't show the transaction type just the transaction number, nominal account, date, details and amount (and it doesn't even total them) - but it does provide a way to get an accurate breakdown of the figures.

Having said that, it would probably be easier to export the figures from the audit trail as a CSV file, throw that into a spreadsheet and get it to analyse the transactions by type.

* In Sage's company mind, everyone has Excel (or Excel is the only spreadsheet), so an ODBC link to that is the only way to go, and there can be no benefit whatsoever to have a button on that (or any other) window saying, perhaps, "CSV"

Hi Vince! Will try and answer as best I can... I am actually using 2013 not 2012!!  DOH!

VinceH wrote:

---

Yet - if I'm reading your first post correctly - there are cash payments, and the VAT return itself is correct, so does include them in the figures?

Yes, there are CP, BP and VP... the summary return is correct, but the detailed doesn't include them.

 

I can't say I've ever encountered that before and, offhand, I can't think of any option within Sage that would lead to that happening. (You can configure tax codes as to whether they are included in the return - but a code that is set that way is excluded from the return figures as well as the detailed reports; it's how T9 is set up by default, for example).

Agreed.  They are all T1 so its not the VAT code that can be creating the issue, as SR and PR are also T1, and are all there.

 

"I can work it out easily using the audit trail in VAT rec order.."

You can also get a breakdown of the transactions from the VAT return itself: Double click on the VAT return to get the basic return up, then click on any of the values to open up a VAT breakdown summary for that box. That window has an option to export to Excel* but (not having Excel I don't know how detailed that is - I suspect it's just that summary) you can then double click on any of the figures to call up a list of transactions, which can itself then be sent to Excel or printed.

Looking at it now, it doesn't show the transaction type just the transaction number, nominal account, date, details and amount (and it doesn't even total them) - but it does provide a way to get an accurate breakdown of the figures.

Having said that, it would probably be easier to export the figures from the audit trail as a CSV file, throw that into a spreadsheet and get it to analyse the transactions by type.

* In Sage's company mind, everyone has Excel (or Excel is the only spreadsheet), so an ODBC link to that is the only way to go, and there can be no benefit whatsoever to have a button on that (or any other) window saying, perhaps, "CSV"

I did try that, before opting to use the audit trail.  When I click box 4, it comes up with the VAT breakdown screen, which shows figures in "purchases payments" and "payments".  I click into payments, and it gives me a little box with a list, but when I try to export to excel, it says 2003, 2007 and 2010 are supported, and I am using the MS365 desktop excel.  Audit trail was just easier than the little box, and it all fell in order with the return, so was no biggie.  

 

---

Hi Jo

I do have the back up (which is 2013, sorry!), as I do the bookkeeping and we pass it back and forth.  The company file was set up by someone else in 2011, which suggests its been updated to 2013 at some point.  It cant have been me, because they were already on 2013 when I took over (she wouldn't be able to open my back up, if she had a lower version, as you know)  

I took over it, to do the Feb14 return.  She sent me the back up, I worked on it and sent it back.  The Feb14 return is fine.  She then sent me a back up to do May14 (which only usually has sales invoices added to it) and the May14 report is the first to omit the payments.

I can only assume something has gone wrong with passing the back ups. Its not adjustments, but that was a good suggestion! I have run both reports and compared them on report designer, and they both have the same entries, so nothing has been changed there.  I'll see if I have an old back up, still.  Its very bizarre, Ive never seen anything like it. 

Thanks for your help, lovelies :)