In this video, we'll dig into everything you need to know about financial reporting in MemberClicks. First we'll touch on what revenue accounts are and why they're used, show you how to create a revenue account, and walk you through how to tie that revenue account to a pricing field on a form. Finally, we'll look at the Transaction Report and talk about filtering exporting the report.
For additional information, check out this financial accounting overview article, which is referenced several times in the video.
For Quickbooks Desktop Users
In the video below, we walk through exporting the Transaction Report as an IIF file and importing it into your Quickbooks Desktop. For Quickbooks users that are not familiar with the IIF import, please see the Quickbooks Support Article. NOTE: It is strongly recommended to backup the company file before importing into Quickbooks.
For Quickbooks Online Users
In the video below, we demonstrate exporting the Transaction Report as a CSV file, making some adjustments to that file in Excel, and importing it into your Quickbooks Online account via a 3rd party import tool (we used Transaction Pro Importer). For a detailed list of the steps required to adjust the CSV file once it's been exported from MemberClicks, check out this article. NOTE: Quickbooks Online pulls payment information from the linked bank account. With this information automatically added QB Online, only the sale, discount and refund transactions need to be imported from MemberClicks. Before downloading the CSV from MemberClicks, be sure to filter the transaction report appropriately by transaction type.
For Non-Quickbooks Users
Non-Quickbooks users can use the transaction report to create a CSV (Comma Separated Value) to import into their accounting software. Some accounting programs, such as Microsoft Dynamics Great Plains, require a 3rd party tool to import from a CSV. This file will include transactions (with the respective debits and credits) and customer level detail. The CSV file can be imported into the accounting software, but formatting needs to be confirmed or possibly adjusted to meet the requirements of your accounting software. NOTE: It is strongly recommended to backup your records before doing any mass import into your accounting software.