- 19 Aug 2022
- 4 Minutes To Read
- Updated On 19 Aug 2022
- 4 Minutes To Read
You can generate the following accounting reports in Mambu:
It is also possible to generate your reports asynchronously via API, for more information, see Accounting Reports API in our API Reference.
Permissions and accounting reports
To view, generate, and print (export) accounting reports, your user needs to have the View Accounting Reports (
VIEW_ACCOUNTING_REPORTS) permission or they need to be an administrator user (admin). For more information, see Permissions - Accounting and Creating a User - Type.
Time range for accounting reports
For all three types of reports, you need to specify the time range for which the report is generated.
Currently, Mambu does not restrict the dates you can specify, so selecting a date in the future is also possible (but of little practical use).
Time range for Balance Sheet reports
For Balance Sheet reports, you can choose between generating a report for a specific month, or generating a report until specified date using the Show option and selecting Month or Date.
When you select Show Month, the Balance Sheet report is created for that month only. If you select the current month, the report is created from the beginning of the month until the current date.
When you select Show Date, the Balance Sheet report is created from the creation of the organization until the date you specify.
Time range for Profit & Loss and Trial Balance reports
For Profit & Loss and Trial Balance reports, you need to specify a starting date and an ending date in the From and To fields, respectively.
Including or excluding zero balance accounts
By default, accounts that do not have any debit or credit for the specified period, also known as zero balance accounts, are excluded from the report. To include these accounts in the report, select More > Show Zero Balance Accounts.
Computing Accounting Reports
Mambu computes accounting reports based on summaries of GL account balances broken down by branch and entry date, after which they are stored daily with the End of Day processes. If the End of Day processes did not run and the account summaries are missing, the balance is computed using the accounting entries (a larger, unaggregated dataset), which could make the generation of the report take a little longer.
The Balance Sheet shows the balances of GL accounts for a specific month, displaying the overall standing of assets, liabilities and equity. It gives you information about the organization's financial situation and the chance to identify potential problems.
To generate a Balance Sheet, go to Accounting > Balance Sheet > choose the specific date or the month and year > Generate Report.
Profit & Loss (or Income Statement)
It shows your organization's revenue and expenses for a given date range or for a month. The difference between the total revenue and the total expense is your business net income. This report's main purpose is to evaluate if your business has made a profit or a loss. A key element of this statement, and one that distinguishes it from a balance sheet, is that the amounts displayed in the Profit and Loss report represent transactions over a period of time while the values on the balance sheet provide financial information at a given moment.
To generate a Profit and Loss report go to Accounting > Profit & Loss > choose a date range > click on Generate Report.
Shows a list of all the accounts in your General Ledger and its balances for a specified date range or month. A trial balance is usually prepared at the end of an accounting period and is used to see if additional adjustments are required to any of the balances. Since the basic accounting system relies on double-entry bookkeeping, a trial balance will have the same total debit amount as it has total Credit amounts.
You can choose what information to display in the report and Mambu will keep your preferences, so the next time you access the Trial Balance report, the columns that you checked will be displayed by default.
Opening Balance shows the accounting balance as of the first day of the selected interval
The Debits and Credits columns show the total net change for each account, where the Net Change is equal to "Debits minus Credits" for Assets and Expenses account; and "Credits minus Debits" for Liability, Equity and Income accounts
Closing Balance displays the accounting balance in the last day of the selected interval
To generate a Trial Balance report: navigate to Accounting > Trial Balance > choose the date range for the report > Generate Report.
Interest accrual breakdown
For more information about accessing the interest accrual breakdown report, see Interest accrual calculation in accounting.
Branch-level accounting reports
If you have several branches in your organization, the Chart of Accounts will apply to the entire organization but you can still have accounting reports at the branch level.
This is possible because:
- for the automatic Journal Entries, Mambu automatically assigns them to the branch to which the client is assigned
- for the manual Journal Entries, you can select the branch to which it should apply when posting the entry.
When exporting or printing any of Balance Sheet, Profit & Loss or Trial Balance reports, the resulting document will include the selected ‘Branch’ information in the header.