Customer questions, answered
Customers in fiscal50 hold the details used on every invoice, proposal and payment. You can add them one at a time or import a list, edit them later, and see each customer’s sales, payments and balance on the customer dashboard. The customer ledger lists every transaction that changed what a customer owes, and the timeline shows what happened in date order. The sales dashboard sums up sales across all customers. These questions cover each of those screens.
Customer management · Invoicing
- Sales Dashboard
- View & Edit Customers
- Add Customer
- Import Customers
- Customer Dashboard
- Customer Ledger
- Customer Timeline
Updated
Sales Dashboard
What is the Sales Dashboard?
A one-page summary of your receivables: how much customers owe, which invoices are due or overdue, how fast customers pay, and who your top customers are.
What does the "As on" date mean?
It is the date the dashboard figures are calculated to, normally today.
Which year does the dashboard show by default?
The current year.
What is Total Customers Receivables?
The total amount all your customers currently owe you.
View & Edit Customers
What does DOJ mean?
Date of joining. It is the date the customer was added, or the date you entered on the Add Customer form.
What is the difference between Credits and Current Balance?
Credits is money the customer has available to use, such as advances. Current Balance is the amount the customer currently owes you.
What does the Status column show?
The customer's status, such as Active.
What icons are in each customer row?
Dashboard, Ledger, Timeline, Edit (pencil), Receive Advance (wallet) and the Action (gear) button. Each opens that task for the customer in the row.
Which fields are required when adding a customer?
Display name and Terms. On the detailed form, Customer Type is required, and so is Company name for companies.
Can I add more details after saving?
Yes. Both forms create the same customer record — click the Edit (pencil) icon in the customer's row on the Customers list to add or change details.
What happens after I save a new customer?
The customer is added to the Customers list, with their date of joining shown as DOJ, and any opening balance becomes the opening balance in their ledger. You can invoice them straight away.
Can I add a customer from other screens?
Yes — for example from the ⋮ menu of the Receivables panel on the Application Dashboard (Add Customer), from the Deposits screen in Banks (Add Customer or the floating footer buttons), from Checkout (+ New customer, which saves the name only) and during registration on the Opening Entries page. Complete their details afterwards on the Customers list with Edit.
Import Customers
What file format does Import Customers accept?
An Excel file. Each row becomes one customer.
Which fields must each row have?
A display name and payment terms. Required fields on the Add Customer form are also required in the file.
What happens if my import file has duplicates?
Remove duplicate rows before importing. On the review screen, watch the duplicate warnings so a customer already in fiscal50 isn't added twice; duplicate entries are also a common reason rows are skipped.
Can I use import to update customers I already have?
No — import adds new customers. Customers already in fiscal50 are flagged as duplicates on review so you can skip them; change existing customers with the Edit (pencil) icon on the Customers list.
Customer Dashboard
What is the difference between Monthly Revenue and Annual Revenue?
Monthly Revenue is what the customer has been invoiced this month. Annual Revenue is what they have been invoiced this fiscal year.
What does Total Amount Due show?
The total the customer still owes you.
What are Total Credits?
Credit the customer has available, for example from a return or an overpayment.
Why does Qty. Sold show a dash for some rows?
Those rows are services, which aren't counted in units.
Customer Ledger
What does the Customer Ledger show?
Every accounting entry for one customer, showing both sides of each double entry with running balances: the opening balance at the top, then each entry's date, transaction type, transaction ID, account, offset account and debit or credit amount, and the closing balance at the bottom.
What is the opening balance in the ledger?
The customer's balance at the start of the period you're viewing; the ledger runs from it to a closing balance. For a new customer it starts from the Opening Balance entered when they were added — what they owed when you started with fiscal50.
What is the closing balance in the customer ledger?
The balance after every entry in the period you're viewing. It appears at the bottom of the ledger.
What presets does the Report Filter offer?
Presets such as This week, This month, This year and This week to date. Picking one fills the date range for you.
Customer Timeline
What is the Customer Timeline?
The customer's full history as a flow of events — invoices, advances, payments — in date order, from account creation to today. Open it with the Timeline icon in the row.
What events appear on the Customer Timeline?
Each point on the timeline is one event, such as an invoice, an advance or a payment, shown in date order.
Does the timeline show a customer's advances?
Yes. Advances appear as events on the timeline, alongside invoices and payments.
What is the difference between the Timeline and the Ledger?
The Timeline shows the customer's history as a flow of events in date order — handy for answering "what happened when" at a glance. The Ledger lists every accounting entry with accounts, debits and credits, and opening and closing balances.
Related
Related pages
Customer management
Customer list, dashboards, timelines, statements, advances and import.
Read moreInvoicing
Invoices, recurring schedules, retainers, deferred income and customer payments.
Read moreInvoice and proposal questions
Creating and finding invoices, numbering, emails, retainer and scheduled invoices, sales tax, proposals.
Read moreCustomer payment questions
Receiving payments, the income list, online payments, advances and checkout.
Read moreCustomer and vendor report questions
A/R and A/P aging, statements, sales, purchases, revenue, expenses and COGS.
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.