πŸ“ Nominal Ledger Payment Practices - Data Export

Jake
Jake
  • Updated

This feature allows users to export data for reporting relating to Payment Practices. This export will display payment practices for Purchase Ledger and Vehicles.

Going into Accounts > Nominal Ledger > Reporting > Payment Practices

mceclip0.png

There is a Report Type selector where you can choose Purchase Ledger or Vehicles.

There is a Start Date and End Date to select to define the range needed for reporting.  

Once the required criteria has been added, users can select the Export button and this will export the data from the selected Division.

For a Purchase Ledger option, this will bring back results for payments against Vehicles. The data returned will be at Divisional Level, however there will be a branch indicator present in the exported data.

The following screenshot shows the Purchase Ledger Export and the fields displayed:

mceclip1.png

Code – the account code

Account Name – the name held against the account

Country – country set against the account

VAT Category – VAT category type

Terms – displays in terms of the account

Terms in Days – the number of days that relate to the terms

BACS – if BACS is used to pay the supplier

Supplier Reference – will display the invoice reference

Transaction Date – the invoice date

Posting Date – the date this was posted

Value – the value

Due Date – the due date

Date Paid – the date paid

 

The following screenshot shows the Vehicles Export and the fields displayed:

mceclip2.png

Branch – which vehicle branch this relates to

Supplier – the name of the supplier

Vehicle Record ID – the vehicle record ID number

Stock Number – the vehicle’s stock number

VIN – VIN if It is present

New or Used – whether the vehicle is new or used

Adoption Date – the adoption date for the vehicle

Payment Due Date – the payment due date

VAT Invoice Date – the date of the VAT invoice if one was posted

Payment Date – the date the payment was made

Payment Type – the type of payment made

Value – the value of the payment made

Reference – the reference for this payment