Configuring Bank Deposits

<< <%SKIN-STRTRANS-SYNTOC%> >>

Navigation:  HANDLING BANK DEPOSITS >

Configuring Bank Deposits

In DONATION, you can select groups of donations to make up one bank deposit, print a report for that bank deposit, and optionally export a summary transaction representing that bank deposit to one of two accounting programs: Software4Nonprofits ACCOUNTS, or Intuit QuickBooks.

 

Note: The features related to bank deposits are not available with the free Lite version of DONATION.

 

You do not have to use the features in DONATION about bank deposits. They are unavoidably a bit complicated, and organizations have used DONATION with no problems for many years without these features being available. For many users, they can see what will be in their bank deposit with other reports, like the various Reports One Date Donation reports (especially for churches) or various of the Reports Donation All Donations reports, with a suitable date range selected. Also, the features for specifying bank deposits will not work well for users with more complex situations, such as depositing some donations into one bank account, and other donations into another bank account.

 

If you do wish to process bank deposits in DONATION, you first need to do some configuration. You start that with the Maintenance Configure Bank Deposits menu option. That brings up the following window:

 

BankDepositsConfigureWindow

 

Select which accounting program you will be using from the radio buttons.

 

If you are using QuickBooks, the checkbox for "Use Classes as well as Accounts for QuickBooks" will become enabled, and you can check that if you do use classes with your income accounts that match the donation categories in DONATION.

 

Also if you are using QuickBooks, the checkbox for "Export dates as DD/MM/YYYY instead of standard MM/DD/YYYY" will become enabled.  Intuit's documentation about the IIF import file format that DONATION exports to, for importing into QuickBooks, says that dates in such files should always be in the format MM/DD/YYYY. Unfortunately, in our experience at least sometimes if the computer running QuickBooks has a Short Date Format (as set in Windows Control Panel's Region and Language tool) with the day preceding the month (such as DD/MM/YYYY), imports of IIF files with the date in the MM/DD/YYYY format will either fail with an error message, or reverse the day and the month in the import. If you encounter this problem, and the Short Date Format on your computer running QuickBooks is something like DD/MM/YYYY, you will need to check this checkbox.

 

Click Save to save your selection. After that, some messages will come up, and two additional windows for further configuration will be opened for you.

 

First Additional Window

 

The first window is for associating the names of accounts in your accounting program with your Donation Categories in DONATION:

 

AccountsForCategoriesWIndow

 

The first time this window is displayed, it will copy each donation Category name, shown in the left-hand column, to be its first guess at the accounting program Account name, shown in the right-hand column. You can then edit the Account names in that right-hand column to exactly match whatever you have in your accounting program, corresponding to that donation category.

 

The Account name corresponding to each donation category must be the exact name of an Income account in your accounting program, or the eventual import into that program will not work. (Do not include the account number, just the name.) If you are using the ACCOUNTS program, do not use the names of Fund (equity) accounts, even if this is income that should increase that fund balance. Rather, use the name of an Income account that is linked to that Fund account.

 

If you selected QuickBooks, and the checkbox for using Classes, the window displayed above will have an additional column on each row, for the Class, You can fill that in as well, when needed.

 

For QuickBooks, if any of the associated accounts are sub-accounts, you need to put in the full name, for example "Parent Account:Sub Account" (without the quotes). A colon separates each level of parent and sub account. If classes are displayed and you are using sub-classes, they need to be separated by colons in the same way, for example "Parent Class:Sub Class".

 

It's important to understand that for QuickBooks, if there are any mismatches of the account names entered here with your actual account names in QuickBooks, the import of the bank deposit transaction will still be accepted, but it will create new accounts in QuickBooks (all of them considered to be bank accounts!) for the incorrect account names. Sorry, we cannot control this, it's just how QuickBooks transaction importing works! For importing into ACCOUNTS, any mismatched account names will cause the import to be rejected, with a helpful explanatory error message saying exactly what is wrong.

 

Also for QuickBooks, all matched accounts must be Income accounts in QuickBooks (not Other Income, or any other type) or the imports will not work.

 

Although in our testing with QuickBooks 2012 Pro the matching of account names is not case-sensitive (the names can vary in the use of upper and lower case between DONATION and QuickBooks), their documentation is silent on that point, and various websites for other products that integrate with QuickBooks say that the matching is case-sensitive. So it will be safer to use the account names in the exact same case as you have them in QuickBooks. For ACCOUNTS, the matching of account names is definitely not case sensitive.

 

For ACCOUNTS, the Income accounts you use must be bottom-level accounts, i.e. there must not be sub-accounts or sub-sub-accounts underneath them.

 

If you leave any of the Account entries empty, donations with that donation category will never be included in a bank deposit (because there is no account associated with it). Normally you would associate accounts with all categories.

 

When you are finished making changes, Save them, then close the window.

 

Note: If you just need to edit the accounts associated with donation categories, you can access this window by going into Maintenance Configure Bank Deposits and using the Edit Accounts for Categories button. (You will also be prompted to go to this window if you edit categories with Maintenance Donation Categories, after configuring to process bank deposits.)

 

If it is important to have a distinction between receiptable/receipted income and non-receipted income in your accounting program, please see the section on Non-Receiptable Donations for some important details about how this works with bank deposits.

 

Second Additional Window

 

The next window is a variation of the regular Maintenance Donation Paid By Values window, as follows:

 

PaidByValuesWindowWithInclude

 

This allows you to specify which Paid By values for donations are ones that indicate the donation will be included in a bank deposit, and which ones will be excluded (because they get into your bank, and/or your accounting program, in a different way). Review those values carefully, make any desired changes (by checking or unchecking the "Include in Bank Deposit" checkbox) then Save the changes, and close the window.

 

It's important to remember that the values on this window are just the contents of the Cheque # / Paid By drop-down list when you are entering or editing donations, but you can always enter any other value into that field as well (such as actual cheque numbers). Any value that is not on this list is assumed to be a potential part of a bank deposit. (So, if you want to make sure that a Paid By value is excluded from bank deposits, it must be on this list, with the checkbox unchecked.)

 

This window actually replaces the normal Maintenance Donation Paid By Values window once your Bank Deposits have been configured.

 

What happens next?

 

After you have configured your bank deposits, you can create specific bank deposits with the Maintenance Create Bank Deposit menu option.