Expense Claims Summary — Complete User Guide — Two Accounts Web

Comprehensive guide for the Expense Claims Summary report — enabling, creating, reading, and validating the movement of every expense-claim payer's outstanding balance for a period

Table of Contents

1. What Is the Expense Claims Summary Report?
2. Prerequisites — Enabling via the Customize Menu
3. Navigating to the Report
4. The Report List
5. Creating a Summary — Field-by-Field
6. Report Output Columns
7. How the Summary Is Calculated
   • 7.1 Which Transactions Are Included
   • 7.2 Opening Balance
   • 7.3 Expense Claims
   • 7.4 Payments
   • 7.5 Net Movement and Closing Balance
   • 7.6 Drilling Into the Details
8. Related Settings and Configuration
9. Sample Data and Report Output
   • 9.1 Sample Setup
   • 9.2 Report Output
   • 9.3 Calculation Verification
10. Reporting and Accounting Impact
11. Accounting Regulation Validation
12. Common Notes and Best Practices

1. What Is the Expense Claims Summary Report?

The Expense Claims Summary report shows, for each Expense Claims Payer, how much is owed to that payer and how that balance moved over a date range you choose. For every payer it displays:

• the opening balance — the amount outstanding at the start of the period,
• the expense claims raised during the period (new amounts owed to the payer),
• the payments made to the payer during the period,
• the net movement (claims minus payments), and
• the closing balance — the amount outstanding at the period end.

A payer in this context is a person or entity (such as an employee, a sales representative, or a branch official) who pays business expenses out of pocket and claims them back. The report follows the standard balance roll-forward: Closing = Opening + Claims − Payments.

2. Prerequisites — Enabling via the Customize Menu

The report appears under Reports only when the Expense Claims area is enabled for the business. Expense Claims is not shown by default in a brand-new company.

How to Enable

1. Open the Customize Menu from the navigation bar (the hamburger / menu icon).
2. Turn on the Expense Claims tab. (This also enables the Expense Claims list and the forms that create claims and payers.)
3. Once enabled, the report is available under Reports → Expense Claims → Expense Claims Summary.

3. Navigating to the Report

From the main navigation bar:

1. Open Reports.
2. Go to the Expense Claims category.
3. Click Expense Claims Summary.

This opens the report list — every summary you have created (and saved) for the business appears here, sorted by its From Date.

4. The Report List

The list shows one row per saved summary, with three columns:

Each row is clickable:

• Click the row to open the summary output (the payer roll-forward).
• Edit opens the summary form to change the dates or description.

A New Report button at the top creates a fresh summary.

5. Creating a Summary — Field-by-Field

Click New Report to open the summary form. It contains three fields:

1. Enter a From Date and a To Date.
2. Optionally enter a Description.
3. Click Save.
4. The report opens showing the summary output for that period.

6. Report Output Columns

The summary opens with a subtitle:

For the period from {From Date} to {To Date}

One row is shown per Expense Claims Payer (ordered by payer name), followed by a Total row. Five columns are displayed:

All amounts are shown in the business's base currency.

7. How the Summary Is Calculated

The report is built from the General Ledger activity posted to the Expense Claims balance-sheet account (the "Expense claims" clearing account), grouped by the Expense Claims Payer attached to each transaction. Only payers with activity on this account are shown.

7.1 Which Transactions Are Included

• Every General Ledger transaction posted to the Expense Claims account, up to and including the period's To Date.
• Each transaction must be linked to an Expense Claims Payer (transactions without a payer link are not shown).
• Transactions are grouped per payer and split by type: expense claims (raised by the payer) versus payments (amounts paid to settle).

7.2 Opening Balance

The sum of the payer's transactions on the Expense Claims account recorded before the From Date (including any opening-balance entries), with the sign reversed. This equals the net amount owed to the payer at the start of the period.

7.3 Expense Claims

The sum of the payer's Expense Claim transactions dated within the period, with the sign reversed. When an expense claim is recorded, the system credits the Expense Claims account (the business now owes the payer); reversing the sign shows the claim as a positive increase.

7.4 Payments

The sum of the payer's non-claim transactions dated within the period (payments and any other settlement transactions, excluding opening-balance entries), with the sign reversed. When a payment is made, the system debits the Expense Claims account (the debt to the payer falls); reversing the sign shows the payment as a negative reduction.

7.5 Net Movement and Closing Balance

Net movement   = Expense Claims + Payments
Closing balance = Opening balance + Net movement

Roll-forward:  Closing = Opening + Claims − Payments

7.6 Drilling Into the Details

The Expense Claims, Payments, and Net movement cells are clickable. Each opens the underlying General Ledger transactions for that payer within the period, filtered to the relevant type (claims, payments, or both). This is where you trace exactly which documents produced the figures.

8. Related Settings and Configuration

9. Sample Data and Report Output

The following example uses the base currency BDT and runs the summary for the first quarter of 2026: 1-Jan-2026 to 31-Mar-2026.

9.1 Sample Setup

Two Expense Claims Payers exist: Branch Operations — Travel and Office Admin — General.

9.2 Report Output

For the period from 1-Jan-2026 to 31-Mar-2026

9.3 Calculation Verification

Branch Operations — Travel:

Opening balance   = 10,000 (prior-period claims outstanding)
Expense Claims    = 5,000 (EC-001) + 3,000 (EC-002) = 8,000
Payments          = 4,000 + 6,000 = (10,000)
Net movement      = 8,000 + (10,000) = (2,000)
Closing balance   = 10,000 + (2,000) = 8,000  ✓

Office Admin — General:

Opening balance   = 2,000
Expense Claims    = 1,500 (EC-010)
Payments          = (2,500)
Net movement      = 1,500 + (2,500) = (1,000)
Closing balance   = 2,000 + (1,000) = 1,000  ✓

Total verification:

Opening balance  = 10,000 + 2,000 = 12,000  ✓
Expense Claims   = 8,000 + 1,500 = 9,500   ✓
Payments         = (10,000) + (2,500) = (12,500)  ✓
Net movement     = 9,500 + (12,500) = (3,000)  ✓
Closing balance  = 12,000 + (3,000) = 9,000  ✓

Roll-forward: Closing = Opening + Claims − Payments
            = 12,000 + 9,500 − 12,500 = 9,000  ✓

GL verification (Branch Operations — Travel):

Claim EC-001   →  Dr Travel Expense      5,000
                     Cr Expense Claims            5,000   (owed)
Payment        →  Dr Expense Claims       4,000
                     Cr Bank / Cash                4,000   (settled)
Claim EC-002   →  Dr Travel Expense       3,000
                     Cr Expense Claims            3,000   (owed)
Payment        →  Dr Expense Claims       6,000
                     Cr Bank / Cash                6,000   (settled)

Expense Claims account (this payer):
  Opening credit 10,000
  + credits 5,000 + 3,000   (claims)
  − debits 4,000 + 6,000   (payments)
  = closing credit 8,000  ✓ (matches the summary)

10. Reporting and Accounting Impact

• Balance Sheet: The Expense Claims account is a balance-sheet clearing account. Its balance (the total owed to all payers) appears as part of current liabilities (or the relevant balance-sheet group). The closing total in this report equals that account's balance at the period end.
• Profit & Loss: Each expense claim posts its expense lines to the relevant P&L expense accounts (travel, office, etc.) at the time the claim is raised. The summary itself shows the claim values, which correspond to those expense postings.
• Cash Flow Statement: Paying a claim is an operating cash outflow; the summary's Payments column corresponds to those cash movements.
• Trial Balance: The Expense Claims account balance ties to the closing figure in this report.

11. Accounting Regulation Validation

12. Common Notes and Best Practices

• Run the summary after all claims and payments are recorded. Post every expense claim and every settlement for the period before generating the report so the closing balance is complete.
• Use it as a period-end control. A clean summary shows who is still owed money and what remains to be paid — a practical input for the payables run.
• Drill down to verify. Use the clickable Expense Claims / Payments cells to confirm the figures match the underlying documents.
• Understand the payer scope. Only Expense Claims Payers appear here. Claims paid through an employee's clearing account or a capital account are reported against those accounts.
• Keep payers consistent. Always select the same payer on a claim that is intended to be repaid to that payer, so the balance does not fragment across payer names.
• Check the sign. A negative closing balance would indicate the payer has been overpaid (payments exceed claims) — investigate and correct as needed.

End of Expense Claims Summary Guide