---
title: "Consolidating a Period with Yapla: Best Practices (Canadian accounts)"
description: "Consolidate a period with Yapla to reconcile your payments and invoices in your accounting system: best practices for Canadian accounts. Here is how."
---

[Skip to content](https://support.yapla.com/en-ca/consolidating-a-period-with-yapla-best-practices-canadian-accounts#main-content)

- [English - Canada](https://support.yapla.com/en-ca/consolidating-a-period-with-yapla-best-practices-canadian-accounts)
- [Français - Canada](https://support.yapla.com/fr-ca/consolider-une-période-avec-yapla-bonnes-pratiques-comptes-canadiens)

English - Canada

Show submenu for translations

[More support](https://support.yapla.com/en-ca/kb-tickets/new?hsLang=en-ca) [Customer portal](https://support.yapla.com/tickets-view?hsLang=en-ca)

[![logo-yapla-help-centre](https://support.yapla.com/hs-fs/hubfs/logo-yapla-help-centre.png?width=880&height=119&name=logo-yapla-help-centre.png)](https://support.yapla.com/en-ca/?hsLang=en-ca)

- [Meet](https://www.yapla.com/en-ca/support-meeting?utm_term=plateforme)
- [Yapla Academy](https://academy.yapla.com/)

Open main navigation

Close main navigation

- [Meet](https://www.yapla.com/en-ca/support-meeting?utm_term=plateforme)
- [Yapla Academy](https://academy.yapla.com/)
- - [English - Canada](https://support.yapla.com/en-ca/consolidating-a-period-with-yapla-best-practices-canadian-accounts)
    - [Français - Canada](https://support.yapla.com/fr-ca/consolider-une-période-avec-yapla-bonnes-pratiques-comptes-canadiens)

  English - Canada
  
  Show submenu for translations
- [More support](https://support.yapla.com/en-ca/kb-tickets/new)
- [Customer portal](https://support.yapla.com/tickets-view)
- [Contact us](https://support.yapla.com/en-ca/kb-tickets/new)

[Contact us](https://support.yapla.com/en-ca/kb-tickets/new?hsLang=en-ca)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Yapla Help Centre](https://support.yapla.com/en-ca?hsLang=en-ca)
2. [Simplify my accounting](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca)
3. [Consolidation](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#consolidation)

# Consolidating a Period with Yapla: Best Practices (Canadian accounts)

Bank reconciliations of your payments and invoices made with Yapla in your accounting system are an important task to maintain accurate and up-to-date accounting, and to ensure effective cash flow management for the association.

To consolidate a period with Yapla (Canada), you must ensure that you have properly entered the revenue and expense accounting items (especially transaction fees) as well as their bank accounts. For users of accrual accounting, it is also important to take into account accounts receivable and deferred revenue. By performing these steps accurately, you will be able to quickly consolidate your revenue and bank account entries using the reports provided by Yapla.

**Important**: don't forget to create account 1200 in your accounting system to gather the amounts receivable from your Yapla credit card account.

In this article, you will find a quick and adapted technique for all accounts with the Essential, Plus, or Premium packages. The last step is specific to Premium clients who have enabled accrual accounting.

### Consolidate a Period

### Create the Appropriate Accounting Items

Make sure you have properly created your accounting items as they are in your accounting system using Yapla's Accounting feature and used them in your event rates, memberships, etc. It is also recommended to have a bank account-type accounting item for each payment method.

### Determine a Consolidation Period

Determine the period you want to consolidate. It is recommended to do it monthly. Choosing a bi-monthly period is also a common method.

Go to the section *Accounting \> Reports \> Consolidation* and *+ Consolidate a period*. Export in Excel format. If this is your first consolidation, start with a first consolidation from the beginning of your usage up to the day before the chosen period.

![](https://support.yapla.com/hubfs/Knowledge%20Base%20Import/40742015166227.png)

### Processing the Consolidation Report

When processing the report, it is recommended to add two new columns: one named *Credit* and one named *Debit*. You can then enter the amount from the *Total* column into one or the other of the two new columns.

- Revenues and taxes payable should be entered into the credit column.
- Bank accounts, transaction fees, and accounts receivable into the debit column.

| Account Code | Account Name | Number of Transactions | Total | Credit | Debit |
| --- | --- | --- | --- | --- | --- |
| 3100 | Registrations - Training | 1 | $555.00 | $555.00 |  |
| 3103 | Registrations - Webinar | 9 | $575.00 | $575.00 |  |
| 3104 | Membership Fees | 3 | $400.00 | $400.00 |  |
| 3105 | Registrations - Networking | 3/6 | $0.00 |  |  |
| 3102 | Registrations - Revenue Options | 1 | ($841.00) | ($841.00) |  |
| 3301 | Training Revenue | 7 | $575.00 | $575.00 |  |
| 3103 | Job Posting | 2 | $100.00 | $100.00 |  |
| 1000 | Bank |  |  | $686.92 |  |
| 4100 | Transaction Fees | 87 | $48.59 |  | $48.59 |
| 1200 | Yapla Account | 87 | $427.49 |  | $427.49 |
| 2205 | GST Payable | 83 | $98.25 | $98.25 |  |
| 2255 | QST Payable | 83 | $78.65 | $78.65 |  |
| 3107 | Other Revenue | 1 | $15.00 | $15.00 |  |
| 3108 | Donations | 3 | $157.15 | $157.15 |  |
| 3109 | Registrations - Golf | 392 | ($270.00) | ($270.00) |  |
|  |  |  | $308.02 |  | $308.02 |

### Verifying Revenue and Tax Totals

Export the [*Sales by Accounting Item* report](https://support.yapla.com/en-ca/articles/40150747423251-using-the-sales-by-accounting-item-report?hsLang=en-ca) for the same period. If you want to verify the bank account entries, export the General Ledger for the same period.

**If applicable**: Export the accounts receivable report if you are using accrual accounting.

You can now, using your processed consolidation report, enter everything into your accounting system. Don’t forget to create account 1200 in your accounting system to register the funds that are in your Yapla virtual account (account 1200) and not yet in your bank account.

If you need more advanced training to manage your accounting, feel free to [contact our support team](https://support.yapla.com/hc/en-ca/requests/new?hsLang=en-ca).

- [Getting started on Yapla](https://support.yapla.com/en-ca/getting-started-on-yapla?hsLang=en-ca#main-content)

    - [Collection of useful resources to discover Yapla](https://support.yapla.com/en-ca/getting-started-on-yapla?hsLang=en-ca#collection-of-useful-resources-to-discover-yapla)
    - [Getting started](https://support.yapla.com/en-ca/getting-started-on-yapla?hsLang=en-ca#getting-started)
    - [Make the most of Yapla](https://support.yapla.com/en-ca/getting-started-on-yapla?hsLang=en-ca#make-the-most-of-yapla)
    - [About Yapla](https://support.yapla.com/en-ca/getting-started-on-yapla?hsLang=en-ca#about-yapla)
- [Configure my account](https://support.yapla.com/en-ca/configure-my-account?hsLang=en-ca#main-content)

    - [First steps](https://support.yapla.com/en-ca/configure-my-account?hsLang=en-ca#first-steps)
    - [Account](https://support.yapla.com/en-ca/configure-my-account?hsLang=en-ca#account)
    - [Billing](https://support.yapla.com/en-ca/configure-my-account?hsLang=en-ca#billing)
    - [License and users](https://support.yapla.com/en-ca/configure-my-account?hsLang=en-ca#license-and-users)
    - [Frequently asked questions](https://support.yapla.com/en-ca/configure-my-account?hsLang=en-ca#frequently-asked-questions)
- [Learn about common functionalities](https://support.yapla.com/en-ca/learn-about-common-functionalities?hsLang=en-ca#main-content)

    - [Communications](https://support.yapla.com/en-ca/learn-about-common-functionalities?hsLang=en-ca#communications)
    - [Forms](https://support.yapla.com/en-ca/learn-about-common-functionalities?hsLang=en-ca#forms)
    - [Pictures and media](https://support.yapla.com/en-ca/learn-about-common-functionalities?hsLang=en-ca#pictures-and-media)
    - [Frequently asked questions](https://support.yapla.com/en-ca/learn-about-common-functionalities?hsLang=en-ca#frequently-asked-questions)
- [Manage my payments and authentification](https://support.yapla.com/en-ca/manage-my-payments-and-authentification?hsLang=en-ca#main-content)

    - [Authentification](https://support.yapla.com/en-ca/manage-my-payments-and-authentification?hsLang=en-ca#authentification)
    - [Payment method](https://support.yapla.com/en-ca/manage-my-payments-and-authentification?hsLang=en-ca#payment-method)
    - [Voluntary contribution and commission](https://support.yapla.com/en-ca/manage-my-payments-and-authentification?hsLang=en-ca#voluntary-contribution-and-commission)
    - [Frequently asked questions](https://support.yapla.com/en-ca/manage-my-payments-and-authentification?hsLang=en-ca#frequently-asked-questions)
- [Manage my members](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#main-content)

    - [First Steps](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#first-steps)
    - [Import members](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#import-members)
    - [Simplified Membership Campaign](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#simplified-membership-campaign)
    - [Member management](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#member-management)
    - [Member profiles](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#member-profiles)
    - [Form](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#form)
    - [Communications](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#communications)
    - [Organization or family management](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#organization-or-family-management)
    - [Membership management](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#membership-management)
    - [Rates](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#rates)
    - [Organization or family](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#organization-or-family)
    - [Advanced functions](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#advanced-functions)
    - [Continuing education](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#continuing-education)
    - [Frequently asked questions](https://support.yapla.com/en-ca/manage-my-members?hsLang=en-ca#frequently-asked-questions)
- [Organize my events](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#main-content)

    - [First steps](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#first-steps)
    - [Settings](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#settings)
    - [Forms](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#forms)
    - [Electronic tickets](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#electronic-tickets)
    - [Advanced settings](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#advanced-settings)
    - [Communications](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#communications)
    - [Rate management](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#rate-management)
    - [Event registration management](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#event-registration-management)
    - [Activity management with sessions](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#activity-management-with-sessions)
    - [Conferences](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#conferences)
    - [Frequently asked questions](https://support.yapla.com/en-ca/organize-my-events?hsLang=en-ca#frequently-asked-questions)
- [Receive donations](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#main-content)

    - [First Steps](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#first-steps)
    - [Donation management](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#donation-management)
    - [Tax receipts](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#tax-receipts)
    - [Recurring donation](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#recurring-donation)
    - [Campaign management](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#campaign-management)
    - [Peer-to-peer campaign (P2P)](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#peer-to-peer-campaign-p2p)
    - [Donor management](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#donor-management)
    - [Frequently asked questions](https://support.yapla.com/en-ca/receive-donations?hsLang=en-ca#frequently-asked-questions)
- [Create my website](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#main-content)

    - [First steps](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#first-steps)
    - [Website personalization](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#website-personalization)
    - [Pages](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#pages)
    - [Modules](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#modules)
    - [Content and articles](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#content-and-articles)
    - [SEO & Performance Tools](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#seo-performance-tools)
    - [Frequently asked questions](https://support.yapla.com/en-ca/create-my-website?hsLang=en-ca#frequently-asked-questions)
- [Simplify my accounting](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#main-content)

    - [First Steps](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#first-steps)
    - [Manage sales and invoices](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#manage-sales-and-invoices)
    - [Manage expenses](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#manage-expenses)
    - [General ledger](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#general-ledger)
    - [Consolidation](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#consolidation)
    - [Reports](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#reports)
    - [Settings](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#settings)
    - [Projects](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#projects)
    - [Taxes](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#taxes)
    - [Frequently asked questions](https://support.yapla.com/en-ca/simplify-my-accounting?hsLang=en-ca#frequently-asked-questions)
- [Manage my contacts](https://support.yapla.com/en-ca/manage-my-contacts?hsLang=en-ca#main-content)

    - [Manage contact](https://support.yapla.com/en-ca/manage-my-contacts?hsLang=en-ca#manage-contact)
- [Send newsletters](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#main-content)

    - [Introduction to Yapla Newsletters](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#introduction-to-yapla-newsletters)
    - [Configure your Newsletters](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#configure-your-newsletters)
    - [Contacts management](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#contacts-management)
    - [Performance tracking](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#performance-tracking)
    - [Webinars](https://support.yapla.com/en-ca/send-newsletters?hsLang=en-ca#webinars)
- [Manage my data](https://support.yapla.com/en-ca/manage-my-data?hsLang=en-ca#main-content)

    - [First Steps](https://support.yapla.com/en-ca/manage-my-data?hsLang=en-ca#first-steps)
    - [Settings](https://support.yapla.com/en-ca/manage-my-data?hsLang=en-ca#settings)
    - [Object management](https://support.yapla.com/en-ca/manage-my-data?hsLang=en-ca#object-management)
    - [Reports](https://support.yapla.com/en-ca/manage-my-data?hsLang=en-ca#reports)
- [Documentation for developers](https://support.yapla.com/en-ca/documentation-for-developers?hsLang=en-ca#main-content)

    - [Advanced functions](https://support.yapla.com/en-ca/documentation-for-developers?hsLang=en-ca#advanced-functions)
- [Manage my federation](https://support.yapla.com/en-ca/manage-my-federation?hsLang=en-ca#main-content)

    - [Getting started](https://support.yapla.com/en-ca/manage-my-federation?hsLang=en-ca#getting-started)

- Our pricing 
    - [Pricing](https://www.yapla.com/en-ca/pricing)
    - [Professional Services](https://www.yapla.com/en-ca/professional-services)
    - [Training hours bank](https://info.yapla.ca/en/services)
- Resources 
    - [Help Centre](https://support.yapla.com/)
    - [Yapla Academy](https://academy.yapla.com/?utm_campaign=website&utm_medium=footer&utm_source=academie)
    - [Blog](https://www.yapla.com/en-ca/blog/)
    - [Yapla Newsletter](https://www.yapla.com/en-ca/yapla-newsletter/)
- Discover Yapla 
    - [Demo and webinars](https://www.yapla.com/en-ca/webinars)
- About Yapla 
    - [About us](https://www.yapla.com/en-ca/about-us/)
    - [Work with us](https://info.yapla.ca/en/work-with-us)
    - Contact Yapla
    - [Become partner](https://www.yapla.com/en-ca/partner-program/)

[![Yapla](https://support.yapla.com/hubfs/logo-yapla-fr.svg "Yapla")](https://www.yapla.com)

<https://www.facebook.com/Yapla.ca.en> <https://www.instagram.com/yapla.ca_en/> <https://www.youtube.com/Yapla> <https://www.linkedin.com/company/yaplacommunity/>

Copyright © 2013-2026, Yapla

[Terms of use](https://www.yapla.com/en-ca/terms-of-use)| [Privacy policy](https://www.yapla.com/en-ca/privacy-policy)