Importing purchase payments in bulk

SOLVED

Hi,

Does anyone know how to fill in the fields on the bulk import file for a Purchase Payment? I can do it for bank payments for likes of wages, bank charges etc that post directly to a nominal ledger but got stuck on the Supplier Payments. 

Type must be PA I'm thinking but is Account Reference the Bank code or the Supplier code? And if its one then where does the other go?? 

These are the fields

Type Account Reference Nominal A/C Ref Department Code Date Reference Details Net Amount Tax Code Tax Amount Exchange Rate Extra Reference User Name Project Refn Cost Code Refn Country of VAT Report Type Fund

Many thanks

Tom 

Parents
  • 0
    verified answer

    Hi Tom,

    Thanks for using Community Hub.

    Regarding the transaction type, you're right, they would need to be imported as payments on account (PA) and then allocated to the invoices in Sage 50 Accounts. 

    The Account reference is the supplier account reference and the Bank would be added in the Nominal A/C ref column.

    There are a series of import templates that you can use, the following article explains how to access them: Import Templates >

    The following is a guide to the import routine: How do I import data? >

    If this helps, please click Verify Answer.

    Regards,

    Andy
    Sage UKI

Reply
  • 0
    verified answer

    Hi Tom,

    Thanks for using Community Hub.

    Regarding the transaction type, you're right, they would need to be imported as payments on account (PA) and then allocated to the invoices in Sage 50 Accounts. 

    The Account reference is the supplier account reference and the Bank would be added in the Nominal A/C ref column.

    There are a series of import templates that you can use, the following article explains how to access them: Import Templates >

    The following is a guide to the import routine: How do I import data? >

    If this helps, please click Verify Answer.

    Regards,

    Andy
    Sage UKI

Children