We have a bespoke database system for our business (selling holidays) and the database exports spreadsheets daily for import to Sage. In simple terms, the spreadsheet records payments and refunds using BR/BP and CR/CP into a holding account, and then (later) JD/JC to transfer funds from the holding account into the relevant income nominal codes. VAT is accounted for as part of the JD/JC process.
The problem I have is that Sage treats all items credited to P&L as outputs for VAT purposes and and debits as inputs. However if we're dealing with a refund or cancellation, then this is not an input, it's a 'reverse' output. But I can't think of a way of telling this to Sage. Consequently, our VAT return wrongly records 'reverse' outputs as inputs.
Is there any way that I can communicate this to Sage as part of the import?
Hi James There is a way but it may be easier if I look at your export sheet if you dont mind then Ill try and work out the columns - apologies I just cannot see what your looking for. please feel free to email info@completebookkeeping.co.uk and Ill be happy to look at it. Only need a couple of lines.
__________________
Donna Curling - Complete Book-Keeping Ltd (CBKLtd) - 07939 101900
