Does anyone know is it possible to import csv files with purchase payments to credit suppliers accounts? I am doing bank and cash payments, purchase invoices to suppliers accounts,etc and it is fine but sage doesn't seem to accept payments on supplier accounts...
I stayed up late last wednesday trying to get the hang of CSV importing as I realised I had set up a new company as standard VAT when it should have been cash accounting and already posted 100 invoices. Eventually managed to export all invoices to excel; change VAT to cash accounting and then import them back to excel.
I later managed to log onto the customers online business banking and export her statement to excel, then import the sales bank receipts onto sage, but thats as for as I have got up to now.
Thanks Sheila, I will have a look at sage forum. The problem is when I post(import) purchase invoice to supplier a/c the transaction code is PI (purchase invoice) but when I am trying to import purchase payment - PP , sage comes up with illegal transaction code and illegal nominal account error...I am doing all this through import audit trail records.
-- Edited by attilabenko on Thursday 25th of November 2010 10:19:13 AM
Hi, there is a set criteria you have to meet and make sure all columns are correct. Once all in correct column import - File / import. Depending on the version you have will depend on how to import (2010 upwards use a wizard and can import from excel rather than csv), otherwise audit trail option. example of columns is: a = BR/BP (bank receipt/payment) b = supplier account/bank or nominal account no c = nominal account d = dept e = date (must be correct format) f = invoice no/ref g = details h = Net amount i = Tax code j = vat amount (must be 0 if nothing) hope helps
dont forget to take headings out !
let me know if problems - info@completebookkeeping.co.uk
__________________
Donna Curling - Complete Book-Keeping Ltd (CBKLtd) - 07939 101900
After looking in help the audit trail import doesnt appear to have PP in the list of transaction types however it does accept PA which would I assume just leave you needing to match them individually in any case.
Yes, now I know,too. You can make payment on account but it is not going to allocate payment against invoices, there is no PP option. But in this case I might as well enter the payments in sage straight away...
