SmartFusion Modules > Accounting > Bank Reconciliation > Process > Import Deposits by Deposit Date

Recent Changes:
6.211 - When BL system file setting 'Post transactions to FL' is not checked, logic was changed to pull the account Id from debit account on the payments records in Cash Collections detail records.

6.207 - The Import Deposit Detail Report was updated for Fees and Taxes to only show a single entry for when F&T are posted to Cash Collections instead of one entry for CC and one for F&T

6.202 (hotfix) - Corrected issue where cash was pulling the deposit total instead of the receipt total when determining the cash amount.  

6.202 - Fixed an issue in the detail report where returned change was not taken into consideration for the total cash amount   

6.196 - Fixed an issue where the deposit amount was doubling for Fees and Taxes when 'Post transactions to FL' was not set on Business License system file and Fees and taxes were posted to Cash Collections.

6.173 - Added the ability to import Tax adjustments  

Refer to bottom of page for changes prior to version 6.150

Introduction

This process will allow for creating deposits from payments. You can search for amounts received by date and the results will be listed by day in the grid. When processed, a deposit will be created for credit card amounts and a separate deposit will be created for cash/check amounts and mark them as posted. These deposits will show on the Deposit tab when doing a bank reconciliation.

When "Post transactions to FL" is not selected in the Business License System File, payments will need to be posted before appearing in the deposit grid.

Grid Details

Selected
Deposit Date - clicking on the magnifying glass will launch the deposit detail report
Deposit Total
Cash/Check Total
Credit Total
EFT Total
Bank Draft Total
Lock Box Total
Deposit Description

References - Internal Use Only

Bank Rec - Data Setup for Importing Deposits

Changes Prior to Version 6.150

6.146 - When BL is set to "Post transactions to FL", payments will no longer need to be posted before being displayed in the Import Deposits deposit grid; BL EFT payments will now be displayed in the detail report as well as the grid; When making an EFT payment through Fees and Taxes, it will now be displayed in the EFT column instead of the Bank Draft column

6.145 Supplemental - A new deposit detail report was added for each line item in the deposit grid  

6.142 Supplemental - Reverted in 6.143 - Corrected issue with BL transaction being duplicated if posting to Cash Collections. 

6.134 - Updated payment process to ensure that Business License EFT payments which are posted to fund ledger through the Business License module are included when importing deposits.

6.121 - Added the ability to import UB adjustments  
6.89 - Added functionality to handle EFT payment types  
6.87 - Added totals to the grid depicting the grand total of the column and the selected amount for each column  
6.85 - Corrected issue when a deposit contained a payment which included on demand penalty and interest invalid negative deposits were being created.
6.84 - Corrected issue where negative tax ad valorem receipt type entries where not being included in the deposit amount  
6.60 - fixed a bug that was assigning the total of the deposit to the bank amount in the cash receipt master file   
6.59 - Added logic to accept deposits created in UB that have automatic payments recorded