Manual Bank Reconciliations
Use bank reconciliation form to manually match the activity from Gravity to your bank's activity. By entering you ending balance and selecting the transactions that have cleared your bank or credit card your final difference should be $0.
You can Access the bank reconciliations from the Financials->Bank Reconciliations
The bank reconciliation screen separates cash activity into 3 distinct types, similar to your bank statement.
- Deposits - Primarily made up of cash receipts entered in the revenue module.
- Checks - Primarily made up of checks created in the purchasing module.
- Other Items - Service charges, bank fees, JE's and other activity.
To process a bank reconciliation you would:
- Create a New bank reconciliation record.
- Complete the Summary tab with the ending bank balance and dates
- Select the lines on the Bank Lines tab where the transactions have cleared the bank
- If a bank transaction does not exist in Gravity, you can select the "Create Bank Book" to create the transaction in Gravity. See Bank Book Transactions
- When the Difference on the form is $0 you can Save and Complete the bank reconciliation. Completing the form will close the bank reconciliation record.
Select the reconciliation's bank account.
See Bank Accounts
Enter the bank statement's ending balance.
Enter the bank statement's date.
Transactions on or before this date are displayed in the reconciliation. This date should be equal to or later than the bank statement ending date.
Use the grid's top section to view totals of all activity from individual panels and the difference between the bank activity and GL.
Once complete, the difference equals $0.00. Select "Complete" from the action menu to close the bank reconciliation and prevent any changes.
Bank transactions are divided into groups; Deposits, Checks and Other Items. Select the items on each panel that have cleared the bank.
Select the column headings to change the sort or filter for each panel.
This is a link to the Gravity journal transaction. Selecting the link will open a dialog above the form for investigation of the transaction.
Use the check-box to select transactions listed on the bank statement.
Reconciled amount defaults to the transaction amount. If the transaction cleared the bank
for a different amount, enter the bank amount in this field.
Delete a bank reconciliation when there are no open items. Un-check all the items on the screen. Save the existing record.
Use delete on the action bar.