Home

Download this help site
(PDF 80MB)

Download

Financial reports

From the Finances module, you can generate various financial reports to help you manage your organization's finances. You can generate the following kinds of reports:

  • Income report – summary of your income based on the invoices in the system within a selected period and by transaction type.
  • Payments report – summary of payments, donations and refunds, in other words your cashflow transactions. Based on the payments and refunds in the system, within a selected period and by tender type.
  • Aging receivables – list of all contacts with outstanding balances classified by outstanding days.
  • Account statement – statement report for a particular account – list and totals of invoices, payments, refunds and donations.
  • Tax reports – for taxes billed and collected during different time periods.

You can also generate financial reports specific to donations and events from other Wild Apricot modules:

  • Donations report – similar to the payments report but filtered to display donations only
  • Event payments report – shows each event's registrations, fees, and payment received broken down by registration type

These reports can be exported to Excel or to PDF format.

Income report

The income report is a summary of all your income, based on the invoices in the system (see Invoices).

To generate an income report, follow these steps:

 Read more/less
  1. Hover over the Finances menu and select the Reports option.
  2. Click the Income link.
  3. Select the date range – when the income was recorded or received.
  4. Select the invoice/payment type(s) you are interested in. You can filter the report by invoice origin – events, payments, donations, or manually created invoices – or by payment status – fully paid, partially paid or unpaid.

  5. Click Generate report.

The report displays a graphical breakdown of all the income by source...

...followed by a breakdown of income from memberships and events.

Payments report

The payments report displays a summary of payments, donations, and refunds – i.e. your cash flow transactions – based on the payments and refunds in the system (see payments overview).

To generate a payments report, follow these steps:

 Read more/less
  1. Hover over the Finances menu and select the Reports option.
  2. Click the Payments link.
  3. Select the date range – when the payments were recorded or made.
  4. Select the invoice/payment type(s) you are interested in. You can filter the report by online vs offline payments, payment type – invoices, donations, and refunds – and by payment status – fully paid, partially paid or unpaid.

  5. Click Generate report.

The generated payment report shows a graphical breakdown of all the payments by payment tender.

The report is further broken down by invoiced payments, donations, and refunds.

Aging receivables report

The aging receivables report is a list of all contacts with outstanding balances, broken down by the number of days that the balance has been outstanding-- 30, 60, 90 and over 90 days due.

 Read more/less

To generate an aging receivables report, follow these steps:

  1. Hover over the Finances menu and select the Reports option.
  2. Click the Aging receivables link.

Account statement

An account statement lists invoices, payments, refunds, and donations for a particular contact.

 Read more/less

There are two different ways to display an account statement for a contact:

  • From the aging receivables list, click on the contact's name to bring up their account statement.

  • From a contact's record, click the Account statement button.

Taxes report

The taxes report shows the taxes billed and collected during different time periods.

To generate a tax report, follow these steps:

 Read more/less
  1. Hover over the Finances menu and select the Reports option.
  2. Click the Taxes link.

By default, a summary report is displayed.

To view a detailed report, displaying individual entries for each invoice, click Detailed.

By default, the detailed tax report shows the gross amount billed, the taxable amount, and the amount of tax billed (from all invoices, whether they have been paid or not). To view the amount collected (from fully paid invoices only), click Collected

You can filter the report by date. You can select from one of the predefined date filters (last 60 days, this month, this year, last month, last year), or use the calendar controls to select your own date range.

On this page: 

  • No labels
 
Wild Apricot Inc. 144 Front Street West Suite 725, Toronto, Ontario, Canada M5J 2L7