Importing bank transfers into Sage

Importing bank transfers into Sage

Didn't find your answer?

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.

avatar
By johndon68
04th Oct 2011 21:23

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

Thanks (0)
avatar
By MrHopko
06th Oct 2011 17:47

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.

Thanks (0)