What is it?
- Revenue Accounts Management enables tracking, management and export of revenue account data for use in accounting systems.
- Data can be exported as an IIF Quickbooks file or as a CSV for import into other accounting packages.
- There are two system permissions related to Revenue Accounts Management: Access to the management area and access to the report. Access to Revenue Accounts Management requires the Revenue Accounts Management system permission. This system permission can be assigned in Database > Group Management > System Permissions > Advanced Features Admin. Access to Revenue Account Reporting can be assigned in Database > Group Management > System Permissions > Reporting Admin
How to Access
While logged in as an administrator, navigate to Forms > Revenue Account Management.
Creating a new Revenue Account
Create a new revenue account by clicking 'Add a new Revenue Account.'
Give the new account a name (i.e. "Annual Meeting Revenue," "Membership Fees," "T-Shirt Sales," etc.), and add a description (optional).
Next to QuickBooks Debit Account, enter the debit account name.
Next to QuickBooks Credit Account, enter the credit account name.
Note: The debit and credit account names will appear in your QuickBooks chart of accounts. The debit and credit account names must be unique.
Tying a Revenue Account to a form field
After the account has been created, each pricing field on a form can be tied to a specific revenue account. To tie a field to a revenue account, edit the form and navigate to Pricing > Assign Revenue Accounts to Pricing Fields.
Select the revenue account to be tied to each pricing field, as well as the report identifier (if other than Contact Name, the default), then fill in the Memo field. This field will import into the Quickbooks Memo field and can be used to identify the revenue in further detail, to remind you when to 'realize' the account, or for notes. Note: If the memo text is changed after transactions have been submitted, that update will be retroactive for all memos pulled into the revenue account report.
Using the Revenue Account Report
Navigate to Reports > Revenue Account Report
Select the Revenue Account(s) you want to run, then choose the timeperiod for the report. Lastly, select the payment type(s) and credit card type(s) by holding down the CNTRL key on a PC or the Command key on a Mac, and click Submit.
Once you have the results from your report, click on the Export to IIF or Export to CSV icons to export Revenue Account data from MemberClicks.