Statement
The app's most-used report: the full turnover of one account, voucher by voucher, with a running balance broken down by currency. Whenever a customer asks "what's my balance now?", this is where the answer is — and it can go straight to their WhatsApp with one button.
Where This Page Fits
- From the Customers list, the General Ledger, or the dashboard, one click takes you to any account's statement.
- Open items of the account: if the account has open payment commitments (as payer or receiver), receipts awaiting collection, payment readiness, open deposit requests, open cheques or pending documents, a slim amber Open items strip with their counts appears under the page buttons; clicking an item opens that list filtered to this account, and the small WhatsApp icon next to it previews and sends it. If nothing is open, the strip does not appear at all.
- WhatsApp: Send balance (image) sits at the top of the page and is one click; the statement PDF or Excel goes to the account's WhatsApp group from ⋯ More → Send statement via WhatsApp.
- If the account has more than one WhatsApp group (extra groups on the account form), sending the balance or the statement file first asks which group to send to; all other pages always send to the main group.
- If the account has no WhatsApp group but has a phone number, the balance, statement and receipts go to that number's direct chat. The number must include the country code (Iranian mobiles starting with 09 are also accepted); a local number without a country code cannot be sent to, and that account's WhatsApp send buttons stay disabled.
Buttons at the top of the page
-
Before you pick an account, only the account field and the Recent customers chips show; the other filters appear after you pick one. The buttons sit directly under the filters, and only the everyday ones are visible: Update, Send balance (image) (the balance image to WhatsApp in one click), the small ⇈ button and the ⋯ More menu. Everything else is in ⋯ More:
-
Reconciliation, + Task, 👁 Customer view and Settle account (customer accounts only);
-
a Download group: Excel, Excel with confidential (internal only), PDF;
-
a Send statement via WhatsApp group: PDF or Excel.
Active states stay outside the menu so you can see them: while customer view is on, the 👁 Full view button (and the "N hidden rows" badge) sits next to the buttons; the "Open only / Show all" toggle of the unknown-party account is outside too.
- Balance card: when the account has three or more currencies, the balance card becomes two columns (wider) and uses the short labels "Dr / Cr" instead of "Debit / Credit"; the colour still shows the side. Currencies are ordered by their value in the reference currency (the largest balance, debit or credit, first); the same order is used in the balance box of forms, the customer portal, the WhatsApp balance image and the PDF/Excel export summary.
- Open items: open commitments, pending clearance, payment readiness, open deposit requests, open cheques and pending documents appear in one slim amber strip titled Open items under the buttons; each item is a link with its count, with a small WhatsApp icon next to it for preview-and-send. If nothing is open, the strip is not shown.
- Currency flags: the rows of the statement table (and other transactional lists) show only the currency code, without a flag; flags remain in the balance card, currency pickers, rate board, dashboard and currency list.
Filters
| Filter | Description |
|---|---|
| Account | Search by name, number, or phone. |
| From date / to date | The turnover period. |
| Last N vouchers | Defaults to the last 30 vouchers, up to 1,000. The running balance is calculated over the account's whole history — only the display is trimmed: the table runs from oldest to newest, the last row is the newest document, and the «Opening balance» row at the top is the sum of everything before the first row shown; reconciliation totals cover the rows shown only. When a date range is selected this count is ignored and all rows of the range appear; the count selector is disabled in that case. A range of more than 1,000 rows, with or without column filters, shows its newest 1,000 rows; to see older rows, narrow the date range in the filters at the top of the page. When rows are cut, the date of the first shown row appears in the «Opening balance» row. In a date range, the total of filtered rows and the document count always cover all matching rows, including those not shown. An export always covers the whole range or the last N vouchers, not what is on screen: Excel covers a range of up to 10,000 rows in full; PDF has a 1,000-row cap, and an export's button is disabled when the range exceeds its cap, both under «Download» and under «Send statement to WhatsApp»; sending an over-cap range to WhatsApp shows the «narrow the date range» message. |
| Currencies | Multi-select: each search adds one currency to the filter (a chip with ×). While filtered, the balance box shows only those currencies and no net line; “All currencies” clears the filter. The list closes after each pick; tap the box again to add another currency. |
Notes
- "Debit" means the customer owes the exchange; "Credit" is the opposite.
- The customer Excel and PDF only have the voucher's public description; the other party of a transfer and any confidential note never appear in them — only in “Excel with confidential (internal only)”.
- If the account is settled, the last two currencies traded are shown with a zero balance and a "Settled" badge.
Reconciliation (Colouring Rows)
To flag rows while matching, choose Reconciliation from the ⋯ More menu. A four-colour palette (yellow, pink, cyan, purple) and an eraser appear above the table: pick a pen colour and click any row to paint it; clicking again with the same colour (or with the eraser) removes it.
A colour is purely your own internal convention — it has no fixed meaning and is connected to nothing in the program (document editing, funds verification, reports); each time you can assign any colour to any purpose. Colours are shared between users and a painted row stays painted until someone clears it. Above the table you see the sum of each colour's rows per currency — these sums are live and update the moment you paint or clear a row, no page refresh needed —, and you can filter to a single colour (or the uncoloured rows). Colours never appear in the Excel/PDF export.
Unknown-party statement
For the "unknown party" account, only not-yet-identified documents show by default to keep the page clean; the "Show all" button (beside the page buttons, outside the ⋯ More menu) brings back identification and identified documents too; "Open only" switches back. This is a system account with no contact behind it, so the WhatsApp send buttons and the “Customer portal” strip are not shown on its statement.
Column filter: the magnifier next to “Voucher” opens a filter row under the column headers (Voucher, Time, Type, Description, Confidential, Currency, Debit, Credit and Balance). After typing, press Enter, or pick a type or currency. The filter applies to the account's whole history and “Count” is applied after filtering: for example “the last 50 transfers”, not the transfers among the last 50 transactions. With a date range, every match in that range is shown. Each row's currency balance is the real ledger balance, the “Opening balance” row is not shown, and a footer shows the debit and credit totals of the filtered rows per currency. The Excel and PDF exports use the same filters. Esc clears a box, and closing the filter row removes all filters.
The ⇈ button makes the whole page scroll as one piece so the table gets more room; click again to pin the header — your choice is remembered in the browser.
The table has its own scrollbar: however long the list, the header and filter row stay fixed while you scroll, and the filters and balances remain visible at the top of the page.
Sending open items as a WhatsApp image
In the Open items strip, next to each item (open commitments, pending clearance, payment readiness, open deposit requests, open cheques, pending documents) there is a small WhatsApp icon. It builds a neat image card of those items and, after a preview (see below), sends it — together with the "open items caption" template text — to the customer's WhatsApp group (or direct chat). You can edit the caption in the WhatsApp message templates page. The icon only appears for users with WhatsApp permission.
Statement Excel export
Two Excel versions are available (both, plus PDF, under ⋯ More → Download):
- Excel: the customer copy, without the private column; this is the file sent by ⋯ More → Send statement via WhatsApp → Excel.
- Excel with confidential (internal only): the same file plus a “Private” column right after “Description” (as on the page itself). It only carries what no other column has: the transfer counterparty, the trade’s third-party commission and the document’s private note. If the counterparty was “Unknown” and has since been identified, the real party’s name appears next to “Unknown”. Its title, sheet name and file name say outright that it contains confidential data, so it is not sent to a customer by mistake.
Both versions have: a dark header with the account and exchange name, an info card (account name/number, report filter — date range or “last N transactions” — and generation date), a cream frozen header row, borders only on cells that contain data (gridlines off), Latin digits, right-to-left text columns, and a Gregorian date column stored as a real Excel date (for sorting and formulas). The Balance column carries no plus/minus sign; the color tells you what it is: red = debit, green = credit — exactly the rule you already see inside the app. The figures are real numbers, so you can total them and write formulas straight on that column. At the bottom there is a “Summary by currency” table: opening balance, total debit, total credit and closing balance per currency.
The PDF export looks exactly the same (dark header, info card, cream header row, the colors and the summary table), except that it has no Gregorian date column — space is tight in a PDF. No export — not even the Excel with confidential — carries the time a document was recorded; only the date appears (the generation date too): the recording time is not the actual time of the trade, and seeing it can start arguments about rates at different hours.
- Everywhere in the app, hovering over a Jalali date shows its Gregorian equivalent.
- The table starts at the end (latest transactions); scroll up for older ones.
Pending balance (_PEND)
If the account has pending documents (awaiting manager approval), their effect appears in the balance list as a dimmed "CODE_PEND" row with a ⏳ badge, with the documents listed under the card. Display only — not included in the real balance, net, or exports; it disappears on rejection and becomes real balance automatically on approval.
Customer portal
With the "manage accounts" permission you can issue a secure read-only link per customer (the collapsed "🔗 Customer portal" box at the bottom of this page): the customer sees balances (incl. pending), open items and their last 20 movements without logging in — with no other party names. The link is copyable and revocable at any time; issue/revoke is logged. The link has no expiry date. It is voided automatically only when the customer's number changes; after that, create a new link. The portal stays open under the same rule as the app, including the grace period after the subscription ends.
Portal link security: the portal link is hidden from search engines, cannot be guessed, and stops working the moment you press "Revoke link".
Description and notes: one column or two
“Description” is the document’s automatic text: trade rate and amounts with the fee, for a transfer, “Receipt” or “Payment” from the account holder’s point of view, plus the tracking code, the bank name and the bank account holder (IBAN holder) if recorded, and the line memo of a group document. “Notes” is what the user typed in the form. By default both share one column; under Settings → Documents and editing → “Description and notes on statements” you can choose “Two separate columns” to show them apart on this page and in the PDF. The statement Excel always has them in two separate columns. The counterparty’s Nexto account never appears in the description (only in the confidential column); the bank account holder’s name is not confidential and does appear, because the customer needs it to pay.
Writing off small balances
By default the write-off limit is the equivalent of 3 dollars in the reference currency (you can change it, or turn it off with 0, in "Settings → Documents & editing"). A small write off link appears next to any currency balance whose equivalent is below that limit. After clicking and confirming, that balance becomes zero, whether the customer is in debit or credit. The document shows on the statement as "Small balance write-off" and, like any document, can be reversed.
-
Currencies without a board rate cannot be written off (their equivalent is unknown). Blocked accounts and system accounts get no link either.
-
Write-off works on customer accounts only (a cash box or bank balance is real money) and needs the permission to post transfers. A credit balance is money owed to the customer, so it gets its own confirmation.
-
When your calendar is Persian (Jalali), each day header on the statement also shows the Gregorian date, and in the statement PDF the Gregorian date is the second line of the date cell (Excel already has a "Gregorian date" column) — handy for matching foreign counterparties and receipts.
-
With the "two separate columns" setting, the order is "Description, Confidential, Notes", then currency and amounts; the "Excel with confidential (internal only)" uses the same order. With the "one column" setting nothing changes.
Deleted rows in the customer statement
In "Settings → Documents & editing" you choose whether a deleted document and its reversal row appear in customer outputs (statement PDF and Excel, WhatsApp sends, portal). With "Do not show", the pair is left out of the customer view; the final balance is the same (the pair nets to zero on the account) and intermediate balances read as if the mistake was never recorded. The original is hidden only when its deletion happened by the end of the statement period. Inside the app everything stays: the staff statement page and the "Excel with confidential (internal only)" are always complete, and the 👁 Customer view option (in the ⋯ More menu) shows what the customer sees.
The 👁 Customer view option is always in the statement page's ⋯ More menu, even when the exchange shows reversals to customers; each user can use it to see a clean statement (without deleted documents and their reversals) for themselves. The choice is personal and remembered for next time; while it is on, a 👁 Full view button stays outside the menu next to the page buttons so the state is visible, with a small "… hidden rows" label beside it if anything in the current range is hidden; clicking "Full view" switches back. It does not affect the PDF and Excel sent to the customer; those follow only the exchange setting.
Preview before sending to WhatsApp
The WhatsApp icon next to each item in the Open items strip (commitments, deposit requests, receipts awaiting clearance, readiness, cheques, pending documents) does not send straight away: a window opens with the same card that becomes the image, the message text and the recipient group (if the account has several groups, you choose here). “Send to WhatsApp” builds the image from the state at that moment and queues it. If the open items use more than one currency, you can pick one currency or “All” in this window; the preview changes at once and that is what gets sent. If the account has several WhatsApp groups, you pick the group here too; with one currency or one group these choices do not appear.
Permanent colours and selective clearing
The reconciliation palette has six colours (green and orange were added). In “Settings → Reconciliation colours” you write your own fixed use for each colour (the name replaces the colour name everywhere) and can make it permanent. “Clear colours” is now a menu: one specific colour or “All non-permanent colours”, only on the rows of this page; a permanent colour is never bulk-cleared and is removed only with the eraser on the row itself.
Payment commitment parts
For a document that is a part of a payment commitment, its number links to the transfer document itself like any other, and a small commitment badge next to it (for example CMT1065) links to that commitment.
- Reconciliation and the ⇈ button: the ⇈ (collapse header) button decides how reconciliation scrolls. ⇈ off: the header (account card, filters and balances) stays fixed and only the table scrolls; since space is tight, the bottom bar shows only the net result per colour. ⇈ on: the whole page scrolls as one, the header scrolls away and only rows with a sticky column header remain; per-colour totals are shown in full (debits and credits separately, plus the net result when both exist). The colour bar, ↑ and ↓ always stick to the bottom and the customer portal bar is hidden. Keyboard: 1–4 colours, 0 eraser, Esc close. Turning reconciliation or ⇈ on or off keeps you on the same row. Without reconciliation ⇈ works the same way: the whole page scrolls as one and scrolling up brings you back to the header.
- Column widths from the data: short columns (document, time, type, currency, amounts) are exactly as wide as their longest value, and description, private and notes columns get room according to the typical length of their text; a column filled in only a few rows becomes narrow and the description takes the rest. When space is tight, description and notes wrap to two lines (instead of being cut) and the private column shrinks first; hover to see the full text. The PDF follows the same rule: like the page, each day gets a header row (Jalali and Gregorian), trades use the short formula, and a trade's second row shows only the fee, so rows stay on one line.
- Opening balance: at the top of the table, each currency that has a balance before the first shown row, even with no rows in the table, gets an “Opening balance” row: that currency's balance before the first shown row (before the date range or the last N transactions). The running balance continues from this figure. A currency whose opening balance is zero gets no row.
- Custom column widths: as in every other table, drag a header edge; that column trades width with its neighbour and the rest stay put. Numeric and short columns never go below the width of their content. Widths are saved for you; double-click any header edge to return to the automatic layout.
Deferred deliveries
When Settings → Trade settlement is on and the customer has open obligations, a Deferred deliveries card appears above the statement rows. Each line is one side of one trade:
- weekday and due date;
- “Receivable” (the customer must give) or “Payable” (you must give);
- open amount and currency; if part of it is done, “of” the total is shown next to it (e.g. “4,000 USD of 10,000”);
- a link to the trade document;
- a red Overdue badge when the due date has passed.
Automatic closing: the customer's real payments and deliveries automatically close their open obligations; nothing has to be done by hand.
When is it overdue? When the delivery date of one side of the trade passes, it gets an "Overdue" badge.
The account balance is the usual net balance; this card only shows delivery timing and is not shown in Customer view. Deleting or reversing the trade removes its obligations, and editing it rebuilds them (an earlier extension, netting or cancellation stays in place).
Working with each obligation
Under each line are the buttons for that obligation (for users allowed to record transfers):
- Destination account (payable): “+ Destination account” opens the Deposit request form with the customer, currency, the amount still without an account and the trade link filled in; “+ Staged Deposit” does the same when the payer is known. For several destination accounts press it several times; each time only the “No account” amount is suggested. Under the line you see the codes of the destination accounts already recorded, “Assigned … of …” and an amber “No account” badge.
- Record received funds / Record payment: fills the transfer form with this customer, currency and open amount. For gold (18K gram, or serial-numbered bars and coins) “Receive gold pieces” or “Issue gold pieces” opens instead, with the same counterparty.
- Extend: a new due date (the next business day by default) with an optional Late fee: a fixed amount, charged once for this whole extension. The % box next to the amount calculates it from the open amount (the default percent is in Settings → Trade settlement). A customer's late fee is charged to their account; in a double deal you can pass it to the other side of the deal, who lost out because of the delay. If the delay is on your side (payable), the amount is credited to the customer's account. The original due date is kept, and the fee document does not count as a payment of the obligation.
- Cancel trade: opens the buy & sell form reversed: same customer, same amount of the main currency, both sides Cash today. You enter today's rate, and saving closes the original trade's open obligations; the rate difference (profit or loss) stays in the customer's balance. Deleting or reversing the reverse trade reopens the obligations. This button also needs permission to record trades.
- Net: if the customer has both an open receivable and an open payable in the same currency, the “⇄ Net …” button in the card header closes them together; a late fee is optional.
Statement on a phone
On a phone the table has three columns: a short description, the currency, and one amount column that shows debit and credit together (red with “Dr”, green with “Cr”).
- Trade: the main currency row says “Sold” or “Bought” with the rate next to it; the other currency row says “Against”, and any extra row says “Fee”. The trade’s fee text (e.g. “with 5 USD fee received”) appears as a small second line under “Against”, or under the only row if just one row of the trade is visible. A trade that has a separate “Fee” row does not repeat it.
- If the main currency row is hidden by the currency filter, the other row shows “Sold/Bought” with the main currency code and the rate instead of “Against”.
- Transfer: “Payment to …” or “Received from …” with the other party’s name, from this account’s point of view. If it was a deposit to a bank account or IBAN recorded on the payment commitment or deposit request, the bank account holder’s name follows in brackets, e.g. “Payment to Bank Mellat (Ali Rezaei)”.
- The running balance, document number, time and full description open when you tap the row. The final balance is always in the balance card at the top.
Change the account or currency quickly
In every account, currency or WhatsApp group picker, once something is selected, a × button sits right after the selected text: one click clears the previous choice and opens the list to search for a new one — no need to delete the text with Backspace. In filters, clearing doesn't submit the form; pick a new option, or leave it empty to mean “all”.
- Trade or transfer: in the type column, trades have the ⇄ symbol and transfers have →; trades also have an amber bar beside the row. Commitment number on trades: if the commitment button on the trade page is enabled in settings, each trade's commitment or deposit request appears as a small link on that trade's second line («Commitment CMT…» or «Deposit request DRQ…»; click to open it). A ✓ next to the commitment number means it is fully paid; no tick means it still has a remaining amount. The blue badge next to the document number appears only on transfers and means that transfer is a part of a commitment.
- Inbox message reference: the «WhatsApp receipt #…» text added to a document's description when registering from the inbox is not shown in the statement (page, PDF, Excel and customer portal); the message link is on the document page itself.