UPLOADING SUPPLIER INVOICES FROM EXCEL OR CSV

SOLVED

 I want to upload supplier invoices in to sage rather than having to enter them all manually and also bank payments in to a specific bank account. Is it possible and if so where can I get the templates from. I have included a screen shot of the bank payments details I would want to upload.

 

On the screenshot imagine I have 50 lines to enter once a month

 

 

  • 0
    verified answer

    Hi Martin,

    Thanks for using our Product Support Community.

    You can import data, including Audit Trail Transactions such as purchase invoices (PI) and bank payments (BP) into Sage 50 Accounts using either Comma Separated files (*.csv) or Microsoft Excel spreadsheets (*.xls and *.xlsx).

    You can find the templates to do this in Help > About > click the Program Directory path > open the Import Templates folder. You would need to use the Audit Trail Transaction FULL template to import PIs and BPs.

    You can find full details on how to import data into Sage Accounts here.

    If this has answered your question, please click on the ‘This helped me’ link below.