Aantar Books
List reports
Printable lists of your customers, vendors, items, prices and staff: contact lists, phone lists, the item price list, the item listing and the employee contact list.
Where: Reports ▸ List · Reports ▸ Report Centre ▸ Lists
The List reports turn your lists into something you can print, export or hand out: a price list for a customer, a phone list for the office, a contact list for your accountant, or the full item listing with costs, prices and margins. They have no dates, because a phone number or a price is simply what it is today; only the two contact lists take an As of date, for their Balance column.
Where to find them
- Reports ▸ List: Account Listing, Item Listing, Item Price List, Customer Contact List, Customer Phone List, Vendor Contact List, Vendor Phone List and Employee Contact List.
- Reports ▸ Report Centre, category Lists.
Account Listing, the first item on the menu, is filed with the accountant's reports in the Report Centre and is explained in Accountant & Taxes reports.
These reports have no filters: each lists everything of its kind. To narrow one down, use the search box, Filter or column sorting in the report toolbar, then print or export what is shown. See Running a report and Print, export and email a report.
Customer
Customer Contact List
What it answers: every customer, with how to reach them, their terms and what they owe you.
Date: as of a day (today unless you choose another).
Columns:
| Column | What it shows |
|---|---|
| Customer | The customer's business name, or their name when there is no business name. |
| Ref | The customer's reference number. |
| Contact | The person's name, when the customer is a business. |
| Phone | Mobile, or landline when there is no mobile. |
| Email address. | |
| Address | Street, city, province and postal code. |
| Terms | Payment terms, for example 30 days, or On receipt. |
| Balance | What the customer owes you on the As of date: open invoices, opening balances and General Journal charges, less credit memos and payments not yet applied. The same figure as the Customer Balance Summary. A negative balance is a credit the customer holds. |
Rows: every customer (including contacts set up as both customer and vendor), alphabetically, then a TOTAL of the balances.
Drill down: double-click a customer to open their ledger.
Note: Counter sales to the Walk-In Customer are not counted in its balance, as on the Customer Balance Summary. For what is owed invoice by invoice, and how late, use the A/R Aging reports in Customers & Receivables reports.
Customer Phone List
What it answers: just the numbers.
Date: none.
Columns: Customer, Mobile, Landline and Alternate.
Rows: every customer, alphabetically. The subtitle counts them.
Drill down: double-click a customer to open their ledger.
Vendor
Vendor Contact List
What it answers: every vendor, with how to reach them, their terms and what you owe them.
Date: as of a day (today unless you choose another).
Columns: the same as the Customer Contact List, with Vendor in place of Customer. Balance is what you owe the vendor on the As of date: open bills, opening balances and General Journal entries, less vendor credits and payments not yet applied, the same figure as the Vendor Balance Summary.
Rows: every vendor (including contacts set up as both customer and vendor), alphabetically, then a TOTAL of the balances.
Drill down: double-click a vendor to open their ledger.
Note: For which bills are open and how late, use A/P Aging Summary in Vendors & Payables reports.
Vendor Phone List
Columns: Vendor, Mobile, Landline and Alternate.
Rows: every vendor, alphabetically.
Drill down: double-click a vendor to open their ledger.
Item
Item Price List
What it answers: your selling prices, ready to hand to a customer.
Date: none.
Columns: Item, Code, Unit, Price (before tax) and Price inc. tax.
Rows: grouped by category (items with none are under Uncategorised). Inactive items and items marked as not for selling are left out, so the list is safe to share.
Drill down: double-click an item to open it.
Tip: Hide the column you do not want customers to see (for example Price inc. tax for business customers) with Columns before printing.
Note: The prices are the items' standard selling prices. Prices set by Price Levels are not shown.
Item Listing
What it answers: every item, with its cost, price, margin and stock: the catalogue as an accountant reviews it.
Date: none.
Columns:
| Column | What it shows |
|---|---|
| Item | The item (and its variant, where it has variants). |
| Code | Its SKU or code. |
| Category | Its category. |
| Brand | Its brand. |
| Tax code | The sales tax code on the item. |
| Cost | The item's cost. |
| Price | Its selling price. |
| Margin % | (Price less cost) as a share of the price, the way retail quotes margin. It is not a markup on cost. |
| On hand | Quantity across every location; blank for items that do not track stock. |
| Status | Active or Inactive. |
Rows: every item, active and inactive, alphabetically. The subtitle counts them.
Drill down: double-click an item to open it. Click its On hand figure to open Inventory Valuation Detail for that item: every movement in and out, which explains how the quantity came to be.
Related: The Item List; Inventory reports for stock values.
Employee
Employee Contact List
What it answers: everyone with a user account in your company, and how to reach them.
Date: none.
Columns: Employee, Username, Email, Phone, Location, Commission % (for staff set up as sales reps) and Status.
Personal identifiers such as Social Insurance Numbers are deliberately not shown, because contact lists get printed and left on desks.
Drill down: double-click a person to open Sales by Rep Detail for them. Someone with no sales opens an empty report.
Related: Set Up Users and Roles; payroll details are in the Employee Centre.
Common problems
A customer or vendor is missing. Deleted contacts are not listed. Check the Customer Centre or Vendor Centre.
An item is missing from the Item Price List. It is inactive or marked as not for selling. It is still on the Item Listing.
The balance on a contact list differs from the aging report. Check that both use the same date. The contact list also takes off payments received but not yet applied to an invoice or bill, which the aging reports leave out; they show on the customer's or vendor's statement.
Related articles
- Customer Centre and Vendor Centre
- The Item List
- Lists in Aantar Books
- Print, export and email a report
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.