Hi,
I'm looking to import a csv file so i can transfers between bank accounts in Sage. Does anyone know if this is possible and if so how?
Thanks
L
Replies (2)
Please login or register to join the discussion.
Importing bank transfers
Yes, it is possible - bank transfers are just journal entries so can be imported using the standard import routine for importing Audit Trail Transactions.
What I'd suggest is putting a transfer through in the program itself then, in Financials -> Reports, run the Transaction CSV report and save it as a CSV file - the format of the file that is produced is exactly the format that you need to create your CSV file in for importing.
HTH
John
Importing transactions
I'm sure you are already aware but there is a good deal of content in the help section of Sage on importing data. It also tells you the location of some usefull template files that will enable you to structure your importing spreadsheets appropriately. Watch out for excel changing '0' to '-' and also for removing preceeding 00s from any reference numbers you have.
As Johndon68 said - transfers are simply journals.