Accounting Reports
  • 29 Jun 2020
  • 4 Minutes To Read
  • Print
  • Share
  • Dark
    Light

Accounting Reports

  • Print
  • Share
  • Dark
    Light

Overview

You can generate the following accounting reports in Mambu:

Start generating Accounting Reports

This section discusses the common properties and settings for all 3 types of Accounting Reports. Details specific to the individual report types are found in their respective sections below:

Time range for Accounting Reports

For all 3 types of reports, you need to specify the time range for which the report is generated.

Please Note

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.

balance-sheet-month

When you select Show Date, the Balance Sheet report is created from the creation of the organization until the date you specify.

balance-sheet-month

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.

Specify the start and end date for your Accounting Report

Please Note
The maximum range for Profit & Loss and Trial Balance reports is 366 days.

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 Accouns.

Show more options for Balance Sheet

Show zero balance accounts in the Balance Sheet

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.

Balance Sheet

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.

Balance Sheet screen with options to be set in order to Generate the 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.

Profit & Loss screen with options to be set in order to Generate the report.


Trial Balance

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

Please Note
The report can be pulled only for a 366 days maximum range.

To generate a Trial Balance report: navigate to Accounting > Trial Balance > choose the date range for the report > Generate Report.

Trail Balance screen with options to be set in order to Generate the report.


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.

Branch Level Account Reports with information like name of report, period, branch and many more.

Was This Article Helpful?