In Winner you can export the Invoice journal, which contains filed invoices, to a .csv file based on the specific period required. This article provides guidance on exporting, and how to access specific invoice, payment and contract details to review, which can be useful for auditing purposes.
Export a .csv file
-
Begin by accessing the Invoice journal from Project level. Click on Invoice follow-up and select Invoice journal.
-
In the Invoice journal, you can filter for invoices for a certain period. Right-click on the From and To fields in the Selection to select the dates.
Once selected, the journal will update.
-
Click on the drop-down menu Export (.csv) at the bottom right of the window.
-
Choose from the four options available:
- Export invoice headers... = gives an overview of each invoice in the selected range.
- Export payment calendars... = gives payment calendar conditions and amounts for each invoice in the selected range.
- Export registered payments... = gives payments made against each invoice in the selected range.
- Export item lines... = exports detailed data about individual item lines for each invoice of the selected range. See Access individual item lines for more information.
- Select a place to save and enter a name for the .csv file.
- Click Save.
The .csv will now be exported. In some countries, dependent on your local Windows settings, you may need to import the .csv file into an Excel spreadsheet in order to read it. To do this:
Importing a CSV File into Excel
-
Open a blank Excel sheet. From the menu bar at the top select the Data tab, then select From Text/csv icon.
-
Find the CSV file you have created and click Import
-
Click on Load
- Information should now be entered into the spreadsheet.
Access invoice details
- At Project level, click on Invoice follow-up and select Invoice journal.
- In the Invoice journal, filter for invoices for a certain period.
-
Double-click on the relevant invoice to open its details.
Access VAT details based on Contract amount
-
In Invoices and payments, click on the more information button next to Contract amount.
- In VAT amount specification, you can review what amount has been assigned VAT based on this sales contract.
Access VAT details based on Invoice amount
- In invoices and payments, click on the Invoice drop-down.
- Select Details…
- In invoice details, click the more information button next to Invoice amount in the Amounts
section:
- In this VAT amount specification window, you can review what amount has been assigned VAT based on this Invoice.
Access Invoice printouts and export history
Winner stores the history log of each invoice created, which can be accessed in the Invoice details.
- In invoices and payments, click on the Invoice drop-down.
- Select Details…
-
Click the Invoice Export history drop-down to view the date and times of invoice printouts.
Access individual item lines
If you select Export (.csv) > Export item lines… the .csv file will include data taken from the payment calendar This enables you to view essential audit information per item line of the selected invoice(s), for example:
-
Invoice Contract % = taken from the payment calendar and shows the % to be charged of the Gross Sales Price for this item.
-
Gross Sales Price Ex VAT = shows the full price of the item.
-
Invoice Gross Sales Price Ex VAT = shows the actual amount charged on the invoice for this item line based on the invoice contract %.
In the excerpt below you can see that the item code AJT60-03 is split across two invoices (nos. 12 and 13, column A). The invoice contract % is 50% (column L, taken from the payment calendar for this invoice).
This means that half the Gross sales price (column M) will be charged on each invoice (column N).