Export invoices and reports
Reports → Export is for administrators only, and a municipality does not have it. The page has two tabs: Catalog and
History.
Pick an export
The export catalogue
The catalogue is searchable and can be narrowed by category. Two sections sit at the top: Favourites (press the star on
a card to keep it there) and Recently used, the four you ran last. Each card names the formats it produces and when it
last ran. The exports today:
- Property data: every property with customer, address, subcontractor and access notes. Narrow it to Location groups;
a column names each address's group, with the group's ID in brackets. Include prices adds the pricing type and, per
work type, your price and your cost on each address.
- Supplier monthly overview: one row per address per supplier with both sides of the trade. An extra work type counts
as work driven under its own work type.
- Supplier overview per month: one row per subcontractor with invoiced, earned and margin.
- Invoice lines: one row per invoice line for the period, from the invoices you issue and the settlements with your
subcontractors, with the kind of invoice, who raised it and who did the work. Archived invoices are left out unless
you switch on Include archived invoices. A subcontractor exporting sees only its own side of a settlement, never its
contractor's customer details.
- Archived invoice lines: lines taken off an invoice in the period, both directions.
- Extra services and credit notes: the lines somebody typed rather than the app drafted off a work type, whatever the
invoice's state, archived invoices included. One row per posting, with what the customer is billed and what the
supplier is paid for the same event side by side: a manual line and its mirror on the other invoice are one row, not
two. SnowManager has no credit-note document, so a credit in this file is simply a line with a negative amount,
whatever it is for: money given back to a customer, a deduction agreed with a supplier, or the charge a resolved
complaint puts on a supplier's settlement (see How a complaint is assessed, timed and settled). Such a row reads
Credit in the Type column, and the amount keeps its minus sign, so the money columns sum to what was actually
charged. A line taken off an invoice is not a credit: an archived line is left out of this file altogether and
belongs to Archived invoice lines.
- Shift hours: every shift in the period, with the hours and whether it is approved.
Three more, ISS BTB invoice basis, ISS BYGST invoice basis and ISS UL supplier basis, are built for one customer and
shown only to the business they were granted to. If your catalogue does not list them, they are not yours to run; there
is nothing to switch on.
Set the parameters and run
1. Click the card. The Export parameters panel opens.
The parameters panel
2. Fill in what the export asks for. Fields marked * are required: usually Date range, for the ISS exports (where
granted) also Location groups or one Subcontractor. The others narrow the rows: Customers, Subcontractors, Location
groups, ZIP code (only postcodes you have addresses in), Routes, Work types, Type and Invoice status. Leaving a
filter empty means all. In most exports Subcontractors offers Own business with your company's name first, for the
work nobody else was set to do, that is, what your own crews did; the supplier overview, which has a row per
subcontractor only, does not.
3. ISS UL supplier basis can also E-mail the file to the subcontractor when it is ready. It is off until you tick it.
4. Choose the Format, Excel (.xlsx) or CSV (.csv), and press Run export.
You land on History with the new row highlighted and Queued.
In a CSV file, money is written as a plain number: two decimals and no thousands separator (1038.00, not 1,038.00), in
the decimal mark of the file's language. A spreadsheet reads every amount as a number, so a column sums correctly.
Export from the invoice pages
The customer, hourly and subcontractor invoice pages have an Export button at the top, for administrators. It produces
an Invoice lines file through the same queue, for the side of the ledger the page is about, and the dialog lists the
files already made under Export history; the bell tells you when a new one is ready.
- Nothing ticked: choose the Date range and, if you like, Subcontractors, and whether to Create separate file for each
contractor (a tab each in Excel; in a CSV the rows are gathered under the subcontractor column instead). From the
hourly page the file holds only lines priced by the hour, and from Invoice as Subcontractor only the settlements
raised toward you.
- Invoices ticked: the button reads Export (3) and the file holds exactly those invoices, whatever their dates and
archived ones included: Only the 3 selected invoices are included. There is no period to choose. The selection bar
at the bottom of the list has no export button of its own any more.
- Inside an open invoice: Export exports that invoice only, or only the lines you ticked in it (Only the 2 selected
lines are included.). An invoice that has not been created yet cannot be exported.
On Invoice for Subcontractor, the button with nothing ticked opens that page's own export instead: pick a Template from
the subcontractor exports, the Subcontractors and the Date range.
History
The export history
Every run is listed with Template, Export parameters, Created by, Created, Rows and Status: Queued, Running, Succeeded,
Failed, Cancelled or Expired. Press Download on a succeeded row, or Cancel while it is still working. Narrow the list by
template, status, date range, or Only mine.
You get a bell notification, Export ready: {0}, that opens the row. A file that was produced but could not be mailed
reads Not e-mailed; hover for the reason, then download it and send it by hand. Files are kept for 30 days, after which
the row turns Expired.
See also
- Review and send a customer invoice
- Invoices to and from subcontractors
- Out-of-sync lines