I am a SAGE LINE 50 newbie.
Where can I find details of the file format for importing csv data files for BANK Payments and Receipts?
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Importing Payments and Receipts
Re: Importing Payments and Receipts
If you are still looking, then go to the Sage Help; contents and index; press the index tab and type in CSV file structure and choose the one saying Audit Trail. This will show you what information you need.
I import sales receipts and the information is created in Excel, following the string shown in the above structure, then saved in CSV format and imported into sage. One thing though, we need to put the transaction type in as SA rather than SR. I assume it's because Sales Receipts are created when you match a payment to an invoice and if you are importing then you can't do that. It all goes on as payment to account and means I have to manually match the payment to the invoice through the bank. Back-up before you try in case anything goes wrong and you can always restore! Good Luck
I import sales receipts and the information is created in Excel, following the string shown in the above structure, then saved in CSV format and imported into sage. One thing though, we need to put the transaction type in as SA rather than SR. I assume it's because Sales Receipts are created when you match a payment to an invoice and if you are importing then you can't do that. It all goes on as payment to account and means I have to manually match the payment to the invoice through the bank. Back-up before you try in case anything goes wrong and you can always restore! Good Luck
- brucedenney
- Site Admin
- Posts: 4632
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Importing Payments and Receipts
Note: some of the versions have different formats.
more stuff on importing to Sage 50 here http://import.makingithappen.co.uk/import_sage_csv.htm
more stuff on importing to Sage 50 here http://import.makingithappen.co.uk/import_sage_csv.htm
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 6 guests