Creating a deposit in Sage Intacct

Keywords:   Accounts Receivable, Deposits, Sage

Credit:–  Sage Photo By: FP

Struggling to Keep Your Books in Order? 📊📅

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

👉 Click Here for a Free Consultation!

Account Receivable – Deposits

About deposits

Creating a deposit is the next step in the workflow when you receive payments into an undeposited funds account for Accounts Receivable invoices and advances, and other receipts created in Cash Management.

The deposit ensures that your books reflect the transfer of funds from your undeposited funds account to your bank account when you decide to actually move the collected and held payments to your bank.

You can receive only check and cash payments into an undeposited funds account. Deposits can’t be edited after they post to the General Ledger and appropriate subledgers.

What’s the difference between deposits, automatic deposits, and manual deposits?

The type of deposit you create depends on whether you’re recording payments that already have invoices or you’re recording a single payment and there’s no invoice.

  • When you create a deposit in Cash Management or Accounts Receivable, you’ve already applied payments to invoices using undeposited funds.
    This type of deposit enables you to record payments from multiple customers into one deposit.
  • When you create a manual deposit in Accounts Receivable, you do not have an invoice. You’re recording receipt of money against one customer (for example, an over-the-counter cash sale).
    Intacct automatically creates the matching invoice.

Deposits in Sage Intacct are different from automatic deposits and manual deposits.

All these methods of deposit can be viewed in the bank register. Only undeposited funds for which you create a deposit can be viewed on the Deposits page.

Deposits workflow

The following diagram illustrates the deposits workflow and the posting activity in the GL and subledgers. Remember, you add a deposit only after you receive payments into an undeposited funds account.

  • Intacct automatically posts to the GL and:
  • debits the bank account
  • credits undeposited funds account
  • The deposit is added to the Deposits list and Bank Register.
  • Payments included in the deposit are removed from the list on the Create Deposit Slip page.

When you receive a payment into an undeposited funds account, the payment amount is posted to the General Ledger. The appropriate account is credited, depending on what the payment is for and how your accounts are set up, and debits the undeposited funds account. An appropriate account is credited, depending on what the payment is for and how your accounts are set up, and debits the undeposited funds account. The payment is added to the list of payments that you can deposit on the Create Deposit Slip page.

After you create the deposit, the amount of the deposit posts to the General Ledger. The deposit appears on the Deposits list and the Bank Register report. The bank account is debited and the undeposited funds account that previously held the transaction is credited. The payments you included in the deposit from the list of payments on the Create Deposits Slip page are removed. They are no longer available to be included in other deposit slips.

Undeposited funds account

You use an undeposited funds account to hold checks and cash payments that you are collecting for a future deposit. As you collect checks and cash, you can enter these payments even if you do not know when you will make the deposit or to which bank you will make the deposit.

For example, you make your deposits on Fridays. You collect payments throughout the week and record them. The payments are correctly accounted for in the undeposited funds account. However, the deposit is not actually in the bank account until you complete the Create Deposit Slip page. At that point, the funds are transferred from the undeposited funds account to the bank account. Thus, if you received a large check, but were not yet sure where to deposit it, you could record it when you receive it so that the payment is on the books and preserve your options with regard to which bank to deposit it.

When you select an account for undeposited funds, you cannot select a General Ledger account that’s associated with a bank account, even though that might seem natural. Rather, you should specify an account that can be used as a transfer account so that you can deposit them later. (Were you to choose a bank account, the funds would already be posted to that bank, even though you have not yet deposited them. That would defeat the whole purpose of having an undeposited funds feature.) Typically, you create an account such as 1500 Undeposited Funds. However, you can have a more granular structure of multiple undeposited funds accounts.

Setup for deposits

To create a deposit, you must have completed these tasks:

  • Created an undeposited funds account into which to receive payments.
  • Created a payment summary in Accounts Receivable if you plan to receive payments for AR advances into undeposited funds. Received a payment into undeposited funds that’s not yet deposited.

After making deposits, you can view them in a list. To view a list, go to Accounts receivable > All > Payments > Deposits or Cash management > All > Deposits. To find more information about a particular deposit, select View for the deposit.

Foreign currency transactions

If your company uses foreign transaction currencies, only base currency transactions are available for an undeposited funds summary. If you are receiving foreign-currency payments, you must choose a bank account for the summary instead.

Multi-entity companies

In shared multi-entity companies with multiple base currencies, you can use this feature only at the entity level where the transaction is recorded in the entity base currency. The Deposits menu item is not available for top-level companies.

Single payments to multiple customers

If you receive a single payment for multiple customers at the top level, you must deposit the funds at the top level. The payment will not be visible at the entity level, even if all paid line items are coded to a single entity.

Multiple customer payments received at the entity level can be deposited at either the top level or the entity level.

Create a deposit

When you deposit multiple payments, it’s typical to group the payments and submit them to your bank with one deposit slip. After you deposit payments and receive your bank reconciliation statement, you see one entry with the total deposit amount.

When you record a deposit, the payment must already be received against your undeposited funds account. Deposits automatically post to the General Ledger and appropriate subledgers. Deposits can’t be edited after they are posted.

Create a manual deposit to record a customer payment that’s not made against a specific invoice (for example, an over-the-counter cash sale).

Go to Accounts Receivable > All and select

  • Add
  • next to Deposits.
  • Select the Bank account where you made the deposit, or where you want to make the deposit.
    If you are a multi-currency company, the transaction currency for that bank account appears after you select it.
  • Enter criteria to filter for the exact deposits that you are interested in including, such as the Undeposited funds date, Customer, or Transaction amount.
  • Select Continue to select payments for deposit.
    The payments that appear are payments received into your undeposited funds account.
  • Enter the Date to post the deposit to the General Ledger.
    The default is today’s date, which you can change as needed.
  • For the ID, enter the information that correlates this record in your company with the actual deposit slip from the bank
    If you already made the deposit, enter the transaction number on your bank deposit slip.
    If you have not yet made the deposit, enter a note such as “Deposit slip MM/DD/YY,”.
  • Add any optional Description.
  • To permanently and safely store a digital version of a supporting document, in the dropdown next to Attachment, select an attachment, or select Add, then upload your attachment.
    You can drag and drop your files to add an attachment. To attach a document to multiple journal entries, see Bulk processing.
  • Select the payments to include in the deposit.
  • From the list of payments, find the checks to deposit. The details area lists all the payments that you received, or all payments filtered by the selected payment method. Each payment is a one-line item.
  • For each payment method, select the appropriate checkbox under Deposit.
  • Having trouble finding a single payment that you made to multiple customers?
  • If the payment was received at the top level, you need to deposit it at the top level, even when all paid line items are coded to a single entity. Multiple customer payments received at the entity level can be deposited at either the top level or the entity level.
  • Verify the deposit Total of the payments chosen for deposit at the bottom-left portion of the table.
  • Select Save.

Next steps:

Sage Intacct does three things:

  • Removes the payments that you selected from the list.
    You can’t select them to include in other deposit slips. You can no longer void or reverse these payments.
  • Posts the amount of the deposit to the General Ledger.
    The deposit appears on the Deposits list and the Bank register report.
  • Debits the bank account and credits the undeposited funds account that previously held this transaction.

View a list of deposits

View deposits you made using the Create deposit slip page. From this page, you can drill down into deposit details and reverse or void deposits. You can also print deposit slips. To view the Deposits list, go to Accounts Receivable > All > Deposits.

In multi-entity shared companies, transaction lists at the entity level include transactions created at the top level that are tagged to your entity. To see transactions created at the top level for your entity, select Include top-level transactions at the top of the list.

Print a deposit slip

After you create a deposit, you can print the deposit slip from the Deposits list.

Reverse a deposit

To maintain an audit trail of cash activity, you cannot edit a deposit. To make changes, you can reverse the deposit and then re-create it. For example, you might have entered a deposit that’s missing an Accounts Receivable payment and want to re-create the deposit to include the payment.

You can reverse a deposit if:

  • You have permission to reverse.
  • The deposit has not been reconciled.
  • No items in the deposit (Accounts Receivable payments or Cash Management other receipts) have been reversed.
    You can, however, reverse any of the other items in the deposit.

After you reverse a transaction, you cannot undo the reversal. However, you can create another transaction to replace the original.

  • One line item is the original deposit, now labeled Reversed.
  • The other line item, labeled Reversal, is the reverse of the deposit. The reversal, when combined with the original transaction, serves as an audit trail.

For example, you have a deposit for $500. After reversing, you still have the original $500 deposit, but also a voided deposit for -$500, resulting in a net of zero.

The resulting journal entry debits undeposited funds and credits the bank account. Accounts Receivable payments and other receipts that were in the original deposit are not reversed and are available to be re-deposited.

When you reverse a deposit, a new reversing deposit transaction is created. The reversing deposit is a mirror image of the original deposit but with the debits and credits reversed so that the journal entries zero out the original deposit.

Reverse a payment in a deposit

A deposit includes payments for invoices, Accounts Receivable advances, and Cash Management other receipts that are received into an undeposited funds account. The deposit generates the journal entry to record the transfer of funds from undeposited funds to the bank (debits the bank account and credits undeposited funds).

If necessary, you can reverse a payment in the deposit. For example, you might need to reverse a payment to correct a payment date or handle a bounced check. Reversing a payment creates a new reversing payment to offset the original. The combination of the original payment and the negative reversal produces a net effect of zero and serves as an audit trail.

The new reversing payment has its own GL date so that you can optionally use a different date for the reversing payment than the date on the original payment. The resulting journal entry debits Accounts Receivable (or some other account if another receipt was reversed) and credits the bank account.

After a payment in a deposit has been reversed, the deposit can’t be reversed. You can, however, reverse as many payments in the deposit as you like. Reversing all the payments effectively voids the deposit.

To reverse a payment in a deposit:

  • Optional: In the list of deposits, find the deposit and select View to see details about the payments in the deposit. You can drill down further into each payment.
  • Reverse the payment:

Check out our Free Additional Articles