Customer and vendor report questions, answered
Customer and vendor reports in fiscal50 show who owes you and whom you owe. A/R and A/P aging sort open invoices and bills by how overdue they are, and customer and vendor statements list each one’s activity and balance. Sales by customer, purchases by vendor, the revenue and expenses reports and the credit report show where money comes from and where it goes, and cost of goods sold shows what your sales cost you. These questions cover each report.
Financial reports · Customer management · Vendor management
- A/R Aging
- Sales by Customer
- A/P Aging
- Purchases by Vendor
- Expenses Report
- Revenue Report
- Customer Statement
- Vendor Statement
- Credit Report
- Cost of Goods Sold
Updated
Why can't I choose dates?
The aging always shows what is open today and how late it is today.
Which invoices are included?
Approved invoices that are unpaid or partly paid. Drafts and recurring templates are left out.
Why isn't a customer in the list?
The list shows customers with open invoices today. A customer who owes nothing isn't listed.
Does the Excel or PDF follow my choices?
Yes — the same customer (or all customers) and the same view, Summary or Detail.
Sales by Customer
How do I type a date?
As mm/dd/yyyy, for example 03/31/2026. You can type just the digits — 03312026 — and the slashes are added. Or click the box and pick the day in the calendar.
Which invoices are counted?
Approved invoices dated in the period. Drafts and recurring templates are left out.
Is the amount with tax?
Yes — Invoiced is the invoices' total, with tax.
What does Still open mean?
What is left to pay on those invoices today, after adjustments and payments.
Which bills are included?
Approved bills that are unpaid or partly paid. Drafts and recurring templates are left out, and so are vendor advances.
How are days past due counted?
From the bill's due date to today; without a due date, from the bill's date. Due today or later is Current.
Why isn't a vendor in the list?
The list shows vendors with open bills today. A vendor you owe nothing isn't listed.
Is there a Cash / Accrual choice?
No. An open bill is open whichever method you use.
Purchases by Vendor
Which bills are counted?
Approved bills dated in the period. Drafts and recurring templates are left out, and so are vendor advances.
Expenses Report
What is the Expenses Report?
A list of your expense for a period, broken down by category, sub category and account, with the total for each.
Where do the category and sub category come from?
From the expense category and sub category chosen when the bill or expense was recorded.
What does the report include?
Expenses on vendor bills and expense transactions, expenses posted directly to expense accounts, and cost of goods for inventory products sold.
Why does the same account appear on more than one row?
Several categories or sub categories are mapped to that account. Each combination is shown on its own row.
Revenue Report
What is the Revenue Report?
A list of your income for a period, broken down by category, sub category and account, with the total for each.
Why do some rows show --- in Category and Sub Category?
That income was posted to an income account without a product or service, such as the Opening Income Account or a journal entry.
Is the Revenue Report the same as the Income Report?
Yes. The report is shown on screen as the Revenue Report.
Which filters are available?
Only the date range. Choose a preset or your own dates, then click Apply Filter.
Customer Statement
Why is the balance in brackets?
It's a credit: you owe the customer — for example an overpayment, an advance or a credit note larger than what was open. Apply it to an invoice or refund it.
Which transactions show on the statement?
Every transaction on the customer's Accounts Receivable account in the dates — invoices, payments, credit notes, refunds, journal entries with the customer and opening balances — and on the customer's credit account. Cash sales never touch Accounts Receivable, so they don't show.
What is the opening balance?
What the customer owed at the start of the first day: every transaction before the start date added up.
Why is a customer missing from All customers?
All customers lists those with a balance on the first day or a transaction in the dates. Pick the customer in the list to see a statement with zero balances.
Vendor Statement
Which transactions show on the Vendor Statement?
Every transaction on the vendor's Accounts Payable account in the dates — bills, bill payments, vendor credits, refunds, journal entries with the vendor and opening balances — and on the vendor's credit account. A payment made without a bill, such as a check straight to an expense, never touches Accounts Payable, so it doesn't show.
What is a payee, and why has it no balance?
A payee is someone you pay without bills, such as a landlord. Nothing is owed on Accounts Payable, so its statement lists what you paid them, with Total paid.
Why doesn't All vendors include my payees?
Payees have their own group: pick All payees to see what you paid each of them.
Can I click a line to open the bill?
No — the statement has no links. Look the transaction up in fiscal50 by the number in Details.
Credit Report
What is the Credit Report?
A list of the credit balances you hold with each vendor and customer, available to apply against future bills or invoices.
What does a vendor credit mean?
The vendor owes you money or credit — for example from an advance you paid or an overpayment on a bill.
What does a customer credit mean?
You owe the customer money or credit — for example from an advance they paid or an overpayment on an invoice.
What does $0.00 mean?
There is no unused credit for that customer or vendor.
Cost of Goods Sold
What is the Cost of Goods Sold report?
A report showing the direct cost of the products you sold during a period, from beginning inventory, purchases and ending inventory.
What does cost of goods sold include?
Direct costs of the products sold, such as goods for resale, raw materials, packaging, freight-in and direct labor.
What does it not include?
Marketing, selling, delivery to customers and general running costs. These are operating expenses.
What is cost of goods available?
Everything you had available to sell during the period: beginning inventory plus net purchases and freight-in.
Related
Related pages
Financial reports
Balance sheet, P&L, cash flow, trial balance, ledgers and drill-down.
Read moreCustomer management
Customer list, dashboards, timelines, statements, advances and import.
Read moreVendor and payee management
Vendors and payees in one place: dashboards, advances and 1099 tracking.
Read moreFinancial statement questions
General ledger, trial balance, income statement, balance sheet, cash flow and more.
Read moreCustomer payment questions
Receiving payments, the income list, online payments, advances and checkout.
Read moreVendor and payee questions
Vendors, payees, vendor advances, ledger and timeline, 1099 filings.
Read moreTry it in your own books.
Starter’s first month is free, with no credit card. Already a customer? Sign in and ask Fifty on any screen.
