Showing how to record the bank deposits from undeposited funds in an online accounting system
Concept of undeposited funds and work flow
Undeposited funds are payments from your customers you have received but have not yet deposited to the bank. It keeps cash and checks aside until you aggregate them into one deposit at the bank. Hence recording payments to this account eliminates the risk of a mismatch between receipts and bank deposits, and creates a transparent audit trail for timing differences.
How undeposited funds work and why you should care
At any time between receiving payment and depositing these payments into the bank, your Undeposited funds is where that money stays. This account is useful for preventing posting lots of separate small deposits directly to the bank ledger and tracking which receipts were included in a real-life bank deposit. When implemented appropriately, they provide lesser settlements blurry effort and allow for clean cash flow timing.
Step-by-step process overview
When you record your bank deposits from undeposited funds, a repeatable process eliminates errors. Your steps are going to go something like this: set up, log, put money in the bank and fund reconciliation. Every step is a simple check of matching receipts to amounts on corresponding banks. A sequence follows the ledger keeping it clean and in check.
Prepare the deposit
Make sure you collect all the physical and electronic payment receipts before commencing the deposit. To confirm completeness, pair each receipt with an entry in the undeposited funds account. Double-check amounts, payers and dates to ensure that you do not make posting mistakes down the road. Create a folder, much easier a digital batch to store the receipts that will comprise the deposit.
- Collect deposit batch cash slips and check images
- Download payment lists from sales or payment register
- Validate if the payer names, amounts and dates have matched records
Record payments into undeposited funds
If you have payments coming in, post them directly to an undeposited funds account so that cash flow is tracked. Apply payments to the right customer or invoice so receivables remain correct. Add a brief reference so that you can easily locate the original voucher. Having a common name for each payment reference to make grouping simpler later on.
Create the bank deposit record
The first step is to have a batch of payments available which you can then deposit, make a bank deposit entry that clears off the undeposited funds account. Choose the payments that are associated with this deposit and set them as deposited. Input the date of the deposit and full incoming amount that will show up at bank account. Save the deposit and check that the balance of undeposited funds was correctly deducted.
While physical copies can be secured by the bank vaults, it cannot prevent others from deposit to your account. The check is verified as matching the date on which it's deposited. Make sure deposit total is equal to the sum of payments chosen. Record any cash overage or shortage, and close.
Common Problems And Their Solutions
Commonly, deposit totals will not match the entry on bank statements because payments may have been omitted or duplicated. To investigate, follow each payment from the receipt to the undeposited funds entry and then to the bank deposit. Edit the deposit or rearrange payments between batches to correct simple errors. If you see duplicate receipts, reverse the duplicate entry line and write down the action taken.
- No receipt more often than not translates to an undeposited entry being bypassed
- Duplicates: A payment is accounted for twice by mistake
- Timing differences arise when deposits credit after the bank date
Correcting errors without disrupting records
If you need to correct an entry, use measures that protect your audit trail and reconciliation. Any adjustments that may be needed afterward should be addressed transparently, with clear memos on the adjustment entries so anyone reviewing the ledger knows why this is being adjusted. Do not delete, rather apply offsetting entries or reverse and re-enter correctly. Store all supporting documents related to each correction for later review.
Reconciliation and month-end controls
This can be done by running a reconciliation to confirm that bank records match the ledger, in addition to ensuring undeposited funds are not carried forward or accurately zeroed out. As a first step, verify that the undeposited funds account contains only unreconciled payments.
How to reconcile a bank statement: Identify and compare each deposit in the statement with the deposit records in your ledger. Check timing issues, bank fees or very likely bounced checks that lead to differences in balance.
- Get bank statements and deposit records from the reconciliation period before you start
- Attach each bank deposit to the matching ledger deposit entry
- Record bank fees and bounced items into the proper expense or receivable account
- Finally, fill in the reconciliation and enter any adjusting entries
Internal controls to reduce risk
If possible, have separate functions where the person collecting payments does not also reconcile the bank. Require a manager's approval for large cash deposits and periodic review of undeposited funds. Protect paper receipts and restrict who can see the accounting system user roles. Routine spot checks minimize the risk of theft and accounting discrepancies.
Best practices and tips
Set a schedule for your deposits, and don't let big amounts sit in undeposited funds terminally. By having shorter holding times, there are fewer timing differences and monthly reconciliation becomes less complicated. Always use an established naming system and batching references so you can easily access receipts whenever they are needed. Having staff record payments trained regularly ensures the process remains consistent and reliable.
Tips for preventing common mistakes
When you record payments with credit cards or ACH transfer, instantly record them into undeposited funds rather than create lost records. Consolidate undeposited funds weekly and not let it pile up; catch errors early so they do not have to be dealt with at the end of the month.
Utilize a deposit checklist to ensure each receipt is accounted for prior to the bank deposit. Notify team members who handle payments about any changes made in deposit procedures.
Final summary and closing thoughts
All you need is a practice, some positive discipline and good record keeping for tracking bank deposits from undeposited funds. Break records into clean batches, use the calculator for deposits, confirm they match your cash books and reconcile appropriately. Errors should be traceable with corrections and internal controls still in place to protect cash. By doing so errors can be avoided and time is saved during month end.