Reporting and exporting invoices to your accounting package

Continuing from the section here on managing charges and raising invoices for a specific order, this section will look at how to report and export information for a number of orders in the system.

Under Winery Reports – Client Billing you will have access to two reports:

Billing charges

New Billing Charges Report

This report has the same output as the CSV option from the Charges tab when looking at a particular service order; however, this report will show all charges across your winery for the nominated criteria. Use Excel to view the CSV file in more detail.

Fields included in this report include:
Type
Date occurred
Summary
Operation reference
Order#
Order description
Order reference
Price list
Party
Rendered on invoice
Reversed
Item
Item description
Item external reference
Item tax state
Tax rate
Item type
Line note
Price
Quantity
Discount
Subtotal
Tax
Total (inc Tax)

Invoice generator

New Invoice Generator

For advanced users only this option allows you to generate invoices across the entire winery for any charges still to be invoiced and not just for a single service order. As this can generate a large number of different invoices and no preview of charges is provided (except by using the Billing charges report above) it is not recommend for the average user.

It may however be useful to check the Reprint invoices only option in order to export a large volume of Invoices to your accounting package.

Exporting invoices to your accounting package

vintrace currently supports several accounting package file import formats for invoices:

  • Quickbooks
  • MYOB
  • Xero

In order to export invoices to your accounting package we recommend you use the Invoice generation report but ensure that Reprint invoices only is selected.

Change the Format to match your required accounting package and then click Generate.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *