Aantar

Aantar Books

Print, export and email a report

Print a report to your report printer, save it as Excel, CSV or PDF, or email it as an attachment, with exactly the figures, filters and columns on screen.

Where: Reports ▸ Report Centre

Every report can leave Aantar Books three ways, from the buttons at the left of its toolbar: Print, Export (Excel, CSV or PDF) and Email. All three take the report as it is on screen right now: the period, the basis, the customer, vendor or location it is narrowed to, any search, filters and grouping, the columns you have hidden, the monthly summary or last year's comparison if they are on.

Print

  1. Set the report up the way you want it on paper.
  2. Click Print on the toolbar, or press Ctrl+P.

Aantar Books lays the report out as a PDF and sends it straight to the document printer chosen for this computer in File ▸ Printer Setup…, or to the computer's default printer when none is chosen (see Printer Setup). Nothing opens on screen. A message says what happened:

Message Meaning
Sent to … Printed on the printer named.
This computer has no printer set up. Add one in Printers. Neither a document printer nor a default printer exists. Set one up, then print again.
The document could not be saved for printing. The PDF could not be written to the computer's temporary folder. Try again; if it persists, restart Aantar Books.
Any other reason The printer refused the job. Check it is switched on and connected, then try again.

What a printed report carries

  • The report title, and above it your company name when Company Name is ticked in Customize (see Customise a report).
  • The period, Accrual basis or Cash basis (when Report Basis is ticked) and prepared with the date and time (as Date Prepared and Time Prepared say).
  • The customer's or vendor's name and address in a box at the top, when the report is about one party, the way an invoice prints the customer.
  • INCOMPLETE — row limit reached if the report stopped at its row limit.
  • The filters you applied and how many lines are shown, for example Province is ON (12 of 40 lines), so a filtered printout is never mistaken for the whole report.
  • Headings, subtotals and totals set out as they are on screen, with indentation.
  • Under the figures: every note the report shows (including any does not agree warning), All figures in thousands. when Divided by 1000 is on, and your Extra Footer Line.
  • Amounts written as Customize says: negatives in brackets or with a trailing minus, without cents, in thousands.

Export to Excel, CSV or PDF

  1. Click Export ▾ on the toolbar.
  2. Choose:
    • CSV — Any spreadsheet or accounting import.
    • Excel — .xlsx with real numbers you can total.
    • PDF — Print or email as it looks here.
  3. A save window opens on your Downloads folder with a name such as Balance-Sheet-Standard-20260925-1432.xlsx (the report title, the date and the time). Choose a folder and click Save.
  4. The file opens in the program your computer uses for it, and a message says Exported 42 row(s) to …. If it cannot be opened automatically the message says Saved to … — open it from there.

What an export contains:

  • The title and a line with the period, basis, when it was prepared, INCOMPLETE if it was cut short, and the filters that were on.
  • One row per report line (blank spacer lines are left out), with indentation kept as leading spaces so the account hierarchy survives in a spreadsheet, and subtotal and total rows styled as such in Excel and PDF.
  • The group on every row. A report that groups its lines under headings — Transaction Detail by account, Sales by Customer or Item Detail by customer or item, Purchases by Vendor Detail by vendor, Daily Sales Detail by day, the Audit Trail by user — has the group as the first column of its Excel and CSV files (Account, Customer, Vendor, Item, Day, User), filled on every line and on each group's total. Sort or filter the sheet and every line still says which account (or customer, or day) it belongs to. The PDF keeps the headings as on screen.
  • The General Ledger, as QuickBooks lays it out. Its first column holds each account as a heading on its own row (1100 · Accounts Receivable, with the number when account numbers are on), with the beginning balance in the Balance column; the account's entries follow with that column blank; then Total 1100 · Accounts Receivable with the debits, credits and closing balance. The Excel, CSV and PDF all read this way. An account with a balance and no entries in the period is listed too, with its balance and its total.
  • Numbers as numbers. Amounts are written as plain figures to two decimals (no currency sign, no thousands separators, minus sign for negatives), so Excel can add up a column. Quantities keep up to four decimals. Percentages keep their % sign.
  • The report's notes at the end.

Note: Customize settings (brackets, thousands, no cents) change the printed page only. Exports and emails always carry full, plain figures, so a spreadsheet adds up to the cent.

Email a report

  1. Click Email on the toolbar. The Email this report window opens, showing the report name, its period and how many rows it has.
  2. To is filled with your company's email address. Replace or add to it; separate several addresses with a comma.
  3. Subject is filled with the report name and period, for example A/R Aging Summary — As of 30 Sep 2026. Change it if you like; it cannot be empty.
  4. Message is filled with Please find attached the …. Change it as you wish.
  5. Under ATTACH AS choose PDF (the default), Excel or CSV.
  6. Click Send.

The report is attached as the same file Export would save, and the email goes out on your company's letterhead from Aantar Books' mail service. Each address receives its own email, so recipients do not see each other's addresses. When it has gone you see Report emailed to … (or Report emailed to 3 recipients).

Message in the Email window What to do
Enter at least one email address. Fill in To.
That does not look like an email: … Correct the address shown.
A subject is required. Type a subject.
Could not send: … Nothing was sent; the reason follows. Check the address and your connection and try again.
Sent to 2 of 3. Failed: … Some addresses worked; the failed ones are listed with the reason. Send again to just those.
Nothing to email — this report has no rows. The report is empty for the period and filters chosen.

To send a report automatically every day, week or month, memorize it with a schedule instead. See Scheduled Reports.

Permissions

The Export / Download permission, under Reports ▸ Report Centre in a role, controls both Export and Email on every report and list in Aantar Books. Without it the two buttons are not shown at all. Print is available to anyone who can open the report. See Roles and permissions explained.

Tips

Tip: Before exporting a long detail report for your accountant, use Columns to hide what they do not need; the file carries only the visible columns.

Tip: Excel files from Aantar Books contain real numbers. Select a column and Excel's status bar shows its sum straight away, which is a quick way to check a report against another.

Note: an Excel worksheet and a PDF are both made with Export; to send the report as a PDF or Excel file, use Email, with the format chosen in the window.

Common problems

Problem Fix
The Export and Email buttons are missing Your role does not have Export / Download. Ask an administrator.
Export, Email and Print are greyed out The report has no lines for the period and filters chosen.
Export failed: … The file could not be written (for example the folder is read-only, or a file of that name is open in Excel). Save to another folder or close the file and try again.
The printout is missing the company name or date Tick them in Customize ▸ HEADER/FOOTER (printed).
The exported figures have no brackets or thousands Intended: exports keep plain numbers. Use Print or PDF after setting Customize for a formatted page.

Related articles

Something unclear or out of date? Write to support@aantar.com and name this page.