Customers and Accounts
- Introduction
- How Customers and Accounts Fit Together
- The Customers Page
- Charging a Bill to an Account
- The Accounts Page
- Invoicing an Account
- Recording a Payment on an Invoice
- Credit Limits and Payment Terms
- Closing an Account
Introduction
Some customers do not pay at the till. A company may be billed at the end of the month, and a regular may settle later. Hotel360 handles this with Customers (who they are) and Accounts (what they owe). Owners, managers and accountants use these two pages to keep track of money that is still to be collected.
Both pages are under Office in the side menu. You need the Open Accounts and Customers permission to see them. To add, edit or delete customers, generate invoices or record payments you also need the Manage accounts and customers permission. Each page can also be switched off by your plan, in which case it does not appear in the menu.
How Customers and Accounts Fit Together
- A customer is a record of a person or company: name, phone, billing terms.
- An account is a running tab for that customer. Charges are posted onto it, and payments reduce it.
- An invoice is a formal bill for a group of the account's charges over a period.
There are three kinds of account:
| Type | What it is |
|---|---|
| Corporate | Opened for a Company customer. |
| Walk-in | Opened for an Individual customer, or an anonymous tab with no customer. |
| Room | Opened automatically for a lodge booking (the guest's room folio). |
You do not create accounts on the Accounts page. They are opened when a bill is charged to a customer, when a guest checks in, and so on.
flowchart LR
A[Add customer] --> B[Charge bill to account]
B --> C[Charges build up]
C --> D[Generate invoice]
D --> E[Record payment]
The Customers Page
Open Office > Customers. The page says "Individuals and companies can be charged bills on account." The table has the columns Name, Type (Company or Individual), Phone and Credit limit. A dash means nothing is set.
- Type in the search box (Search name, phone, email...) to find a customer.
- The type box offers All types, Individuals and Companies.
- 15 customers show per page.
Note
The last three digits of every phone number are hidden on screen, for example "0712 345 XXX". The full number is kept, and you will see it when you edit the customer.
Adding a Customer
- Click Add Customer.
- Choose the Type: Individual or Company.
- Fill in Name (the company name for a company) and Phone. Both are required. Email is optional.
- For an individual you can add an ID number (National ID). For a company, the Tax PIN (KRA PIN) and Billing email fields appear lower down.
- Optionally fill in City, Country and Address.
- Under Billing / account terms, set the Credit limit and Payment terms (days) if needed. See Credit Limits and Payment Terms.
- Click Add. You see "Customer created."
The phone number must be unique. The email, if given, must be a valid address and must also be unique. If the number or email is already used by another customer, the form shows an error beside the field. Search for the existing customer instead of adding a second one.
Editing and Deleting a Customer
- Click the ⋯ button on the customer's row.
- Choose Edit to change the details (click Update to save, you see "Customer updated."), or Delete.
Delete asks "Delete this customer?". If the customer already has an account, you get "This customer has an account and cannot be deleted." and nothing changes. Otherwise you see "Customer deleted."
Note
A person who has the Open Accounts and Customers permission but not Manage accounts and customers will see the buttons, but saving or deleting is refused.
Charging a Bill to an Account
This is how charges reach an account. It is done from the bills list, not from the Accounts page.
- Open POS > Bills and find an open bill (status pending or partial).
- Click ⋯ > Charge to Account on the bill's row.
- In Charge to, pick either an in-house room guest (shown as "Rm 106 · Jane W.") or a customer from the list.
- Click Charge to Account. You see "Bill #1234 charged to Jane W.".
The bill stays open with no receipt. It is settled later, on an invoice. A bill charged to a room guest goes onto that guest's room folio and is settled at checkout.
You need the Accept cash or Send STK push permission to charge a bill to an account, the same as clearing a bill. Without it you get "You do not have permission to charge bills to an account." If there is nobody to choose, the window says "Nobody to charge": check in a guest or add a customer first. See Working with Bills.
Service orders can be charged to an account too; see Services.
The Accounts Page
Open Office > Accounts. This is your list of money owed.
Finding an Account
- Search customer or tab... matches the customer's name or the tab's reference name.
- The type filter offers All types, Corporate, Walk-in and Room.
- The status filter offers All statuses, Open, Closed and Settled. It starts on Open, so closed and settled accounts are hidden until you change it.
The table shows Account, Type, Status and Balance (Ksh). An anonymous tab with no name is listed as "Walk-in #" followed by its number. Click View to open the account.
Reading an Account
The account opens in a side panel with three figures:
- Charges: everything posted to the account, except cancelled items and bills on hold. For a room folio this includes the room stay, which grows each day for an open booking.
- Paid: all payments recorded against the account.
- Balance: Charges minus Paid. This is what the customer still owes.
Below the figures are two lists. Invoices shows each invoice with its Total, Balance and Status (Issued, Part Paid, Paid or Void). Charges lists each bill ("Bill #1234") and service order ("Service #56") with its date and amount, and whether it is Invoiced (Yes, or a dash if not yet).
Invoicing an Account
An invoice gathers an account's unbilled charges for a period into one document. You can invoice any account that has a named customer, whether Corporate or Walk-in. Room accounts are settled at checkout, and anonymous tabs have nobody to bill, so the Generate invoice box does not appear for them.
- Open Office > Accounts and click View on the account.
- In Generate invoice, set From and To. They start as the first and last day of this month.
- Click Generate. You see "Invoice INV-... generated (Ksh 12,500.00)." with the new number and total.
The To date cannot be before the From date. The invoice includes bills and service orders in that period that are not already on an invoice, leaving out cancelled ones and bills on hold. Each charge is marked so it is never billed twice. If there is nothing to bill you get "No unbilled charges for this account in the selected period."
The invoice gets a due date when payment terms exist: the issue date plus the number of days. If the account has no terms of its own, the customer's terms are used.
To see or print the invoice, click ⋯ > PDF on its row. It opens a preview headed INVOICE with your business name, the customer, Invoice #, Issued, Due and Period, a table of dates and descriptions with Amount (KES), then Total, Paid and Balance Due. The customer's billing email and tax PIN show under their name if set.
Note
There is no separate customer statement page. To show a customer what they owe, send the invoice PDF, or read the account panel.
Recording a Payment on an Invoice
- Open the account and click ⋯ > Record payment on the invoice. This choice is hidden once the invoice is Paid or Void.
- In Amount (Ksh), the full balance is filled in. Change it for a part payment.
- Choose the Method. The list holds your registered payment modes. Cash appears only for users allowed to accept cash.
- Add a Reference (optional), such as a cheque number or RTGS reference.
- Click Save payment. You see "Payment recorded."
What happens next:
- The invoice becomes Part Paid until the total is covered, then Paid.
- The money is shared across the invoice's charges, oldest first. Bills fully covered become cleared, the next one becomes partial, and the rest stay pending.
- Each bill that receives money gets a receipt for that amount.
- The account Paid and Balance figures update.
The amount must be above zero. If the invoice is already paid or void you get "This invoice is already paid and cannot take further payment." Payments cannot be edited or deleted on this page.
Warning
Check the amount and method before you save. There is no button on this page to reverse a payment.
Credit Limits and Payment Terms
Both are set on the customer, under Billing / account terms.
- Credit limit: the most the account may owe. When a charge would take the balance above it, the charge is refused with "This charge exceeds the account's credit limit of 50,000.00." Pay down the balance and try again. Leave it empty for no limit.
- Payment terms (days): how many days after the invoice date payment is due.
These are copied onto the account when it is first opened. Changing them later on the customer does not change an account that is already open.
Closing an Account
You do not close accounts on the Accounts page. A room account is closed by the system when the guest checks out (see Payments, Deposits and Checkout). When an account closes with nothing owing, its status becomes Settled. If a registered customer still owes money, it becomes Closed and the balance stays to be invoiced. A tab with no registered customer cannot close while it has a balance: you get "An anonymous walk-in tab must be settled before it can be closed. Register a customer to carry a balance."