Deposits & Funds Transfer in Sage Intacct

Keywords: Transactions, Funds, 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!

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.

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.

1. Add payment to undeposited funds

  • Intacct automatically posts to the GL and:
  • credits AR or other account
  • debits undeposited funds account
  • The payment is listed on the Create Deposit Slip page

2. Create deposit

  • 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 Cash Management > 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 Cash Management > 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.

  • Go to Cash Management > All > Deposits.
  • Find the deposit slip and select Print beside it.
    A PDF of the deposit slip appears in a new window.
  • Print or download the PDF.

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.

  • Go to Accounts Receivable > All > Payments > Deposits or Cash Management > All > Deposits.
  • Find the deposit and select Reverse.
  • In the Transaction reversal date window, enter the following information:
  • For Reverse the transaction on date, select the date for reversing the deposit. This is usually the original transaction date or a later date. You can even select a date in a prior closed period so that your financial statements are correct.
  • For Memo, add a description that applies to this deposit. This text is for your information only.
  • Select Submit.

You return to the Deposits list where you can see two line items for this deposit:

  • 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:

Cannot reverse a deposit

The following describes possible reasons for not being able to reverse a deposit and provides solutions for each reason. You do not have permission to reverse a deposit. Ask your administrator to make sure you have at least List, View, and Reverse deposits permissions for the Cash Management application.

The deposit has been reconciled.

After a deposit has been reconciled, the Reverse link no longer appears beside it on the Deposits page. To reverse the deposit, reopen the bank reconciliation. One or more payments or other receipts in the deposit have been reversed. After a payment or other receipt in a deposit has been reversed, the deposit can’t be reversed. You can, however, reverse as many payments or other receipts in the deposit as you like. Reversing all the payments effectively voids the deposit.

Funds transfers

Record the transfer of funds from one cash account to another. Cash accounts include checking accounts and savings accounts. If your company uses foreign transaction currencies, you can transfer funds only between base currency accounts. If your company is based in the US with offices in Canada, you cannot transfer dollars in CAD from the Canadian bank to USD in a base-currency US bank. Nor can you transfer funds between two foreign-currency Canadian banks.

Multi-entity companies

In multi-entity companies with multiple base currencies, you can transfer funds between banks within an entity or across entities. For example, you can transfer funds between Bank of America (USD) and Wells Fargo Bank (USD) because they both use USD. You can also transfer funds between Bank of America (USD) in one entity and Canadian Bank (CAD) in another entity. Funds transfers are recorded in the appropriate bank’s currency. When you transfer funds between accounts with different currencies, enter the amount in the currency into which you’re transferring.

For example, to transfer 75 pesos from a bank with USD currency, enter 75 in the transfer from section. The transfer will be 75 pesos and the originating bank will show the equivalent amount in its currency based on the exchange rate, in this case, in USD (approximately $4 USD).

The following are prerequisites for transferring funds of different currencies.

  • Disable inter-entity transfers is not enabled.
  • Both bank accounts are at the top level.
  • Allow creating, editing and deleting foreign currency transactions is enabled on the Configure Cash Management page.
  • The bank currency matches the corresponding entity base currency for both banks participating in the transfer.

In some cases, accounts could be restricted to certain entities or locations. If the account does not appear in the list for selection, it might be a restricted account.

Scenarios

Depending on what types of accounts to which and from which you transfer funds, one of several scenarios takes place:

  • You could transfer funds from and to the same bank account.
    You could do this between two bank accounts, for example. In this case, the net effect on the General Ledger is zero.
  • You could transfer between the same bank account and its debit card.
    Debit cards draw on the bank account in the same way as a check. Again, the net effect on the General Ledger is null, but the entries are named differently in the register.

Trying to pay off a credit card?

A funds transfer to or from a credit card is not supported.

Record a funds transfer

A funds transfer is a transfer of funds from one cash account to another. Cash accounts include checking accounts and savings accounts. After you create a funds transfer, you cannot void or edit it. Instead, reverse it and then enter another fund transfer with the correct information. You cannot undo a reversal after you submit it. To view account balances to determine if you need to make a transfer, or if there are sufficient funds that can be transferred, go to Cash Management > All > Reports > Cash balances.

Trying to pay off a credit card balance? Funds transfers to or from a credit card are not supported. Instead, go to the Charge payoff page to create a bill for the charges and pay it on the Pay bills page.

  • Go to Cash Management > All and select
  • Add
  • next to Funds transfers.
  • Select the two cash accounts for the transfer:
  • From account: The account to transfer from.
  • To account: The receiving account.
  • After you select the two accounts, the balance and base currency for each account appear. If you choose accounts with different currencies, the Currency section appears for you to make the conversion from one account to the other.
  • Enter the Date on which you actually made the transfer.
  • Enter the Amount of the transfer.
  • Enter the transaction number in the Reference number field.
  • 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.

  • In a multi-entity, multi-currency company, enter the currency details in the Currency section:
  • Transaction currency displays the currency of the receiving account.
  • Type or select a date in Exchange rate date.
    The default value is the current date, but you can override this. For example, you can change it to the date the transfer occurred.
  • In Exchange rate type, select the dropdown to select an exchange rate type such as Intacct daily rate or one you’ve created, such as WSJ Published Rate.
    If you know what the exchange rate for this funds transfer is, enter it in Exchange rate to override system calculations.
  • If you need to do a fund transfer that requires three-way currency conversion, do the conversion manually and book a journal entry directly to the GL.
  • In the Dimensions section, you can set dimension values for tracking and reporting purposes.
  • In addition, Intacct enables you to define new dimensions to suit your needs. Use these user-defined dimensions to organize and sort categories of data unique to your business. For example, if you’re a software company with multiple product lines, you can create a user-defined dimension called Line of business. Then add the values Direct customers, Channel partner, and OEM.
    Dimensions enable you to collect, sort, analyze, and report on data within one category, or between categories, so you can identify key factors such as:
  • Your most profitable or most costly items or customers
  • The return on investment of a project or department
  • Whether and to what degree a new product or product line is successful
  • Which way a particular aspect of your business is trending
  • Intacct dimensions give you fine control over data definition and data hierarchy
  • With dimensions, you can customize financial reports around specific business activities, get greater visibility into how the business is doing, and make faster, more meaningful business decisions.
    Think of dimensions as a more powerful alternative to subaccounts.
    Additional fees can apply for the Project dimension and user-defined dimensions.
  • Select Save.

Funds transfers between entities

A funds transfer is a transfer of funds from one cash account to another. Transfers between entities are done at the top level. You can transfer between accounts with different currencies. Make sure you have the appropriate permissions for both entities.

Trying to pay off a credit card balance? Funds transfers to or from a credit card are not supported. Instead, go to the Charge payoff page to create a bill for the charges and pay it on the Pay bills page. After you create a funds transfer, you cannot void or edit it. However, you can reverse it and then enter another fund transfer with the correct information. You cannot undo a reversal after you submit it. You can view account balances to determine if you need to make a transfer, or if there are sufficient funds that can be transferred, in the Cash balances report

Before you begin

Make sure that the following is true:

  • Both bank accounts are at the top level.
  • Cash Management is enabled to Allow creating, editing, and deleting foreign currency transactions.
  • The bank currency matches the corresponding entity base currency for both banks participating in the transfer.
  • Check account currency
  • Go to Cash Management > All /Setup > Accounts and select the appropriate account type.
  • Select View beside the account that the funds will be transferred from, noting the Currency and Location ID (entity) for the account.
    Select Done to return to the list.
  • Select View beside the account that the funds will be transferred to, noting the Currency and Location ID (entity) for the account.
    Select Done to return to the list.
  • Go to Company > Setup > Entities.
  • Confirm that the currency of each account matches the base currency of the assigned entity.
  • There are no restrictions on the bank accounts.
    In some cases, accounts could be restricted to certain entities or locations. If the account does not appear in the list for selection, it might be a restricted account. See Private and restricted data in multi-entity companies for more.
  • You have inter-entity transactions enabled for the account.
  • Check that inter-entity transactions are enabled
  • Go to Cash Management > Setup and select Checking accounts or Savings accounts, whichever is appropriate to the funds transfer you want to make.
  • Find the account that you want to check.
  • Select
  • More actions
  • > Edit at the end of the row.
  • Go to Accounting information and make sure that Disable inter-entity transfers is not selected.

Transfer funds between entities

  • Go to Cash Management > All > Transactions and select
  • Add
  • next to Funds transfers.
  • On the Funds transfer page, select the two accounts for the transfer:
  • From account: The account of the transferring entity from which you want to transfer
  • To account: The account of the receiving entity
  • After you select the two accounts, the balance and base currency for each account appear. If you choose accounts with different currencies, the Currency section appears for you to make the conversion from one account to the other.
  • Enter the Date on which you actually made the transfer.
  • Enter the Transaction amount.

When you transfer funds between accounts with different currencies, enter the amount in the currency into which you’re transferring.
For example, to transfer 75 pesos from a bank with USD currency, enter 75 in the transfer from section. The transfer will be 75 pesos and the originating bank will show the equivalent amount in its currency based on the exchange rate, in this case, in USD (approximately $4 USD).

  • Enter the transaction number in the Reference number field.
  • Optionally, include a description for the transfer.
  • 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 attachments.
    In a multi-currency company, enter the currency details in the Currency section:
  • Transaction currency displays the currency of the receiving account.
  • Enter or select a date in Exchange rate date. The default value is the current date, but you can override this. For example, you might want to change it to the date the transfer occurred.
  • In Exchange rate type, select the dropdown to select an exchange rate type such as Intacct Daily Rate or one you’ve created, such as WSJ Published Rate.
    If you know what the exchange rate for this funds transfer is, enter it in Exchange rate to override system calculations.
  • If you need to do a fund transfer that requires three-way currency conversion, do the conversion manually and book a journal entry directly to the GL.
  • In the Dimensions section, you can set dimension values for tracking and reporting purposes.
  • In addition, Intacct enables you to define new dimensions to suit your needs. Use these user-defined dimensions to organize and sort categories of data unique to your business. For example, if you’re a software company with multiple product lines, you can create a user-defined dimension called Line of business. Then add the values Direct customers, Channel partner, and OEM.
    Dimensions enable you to collect, sort, analyze, and report on data within one category, or between categories, so you can identify key factors such as:
  • Your most profitable or most costly items or customers
  • The return on investment of a project or department
  • Whether and to what degree a new product or product line is successful
  • Which way a particular aspect of your business is trending
  • Intacct dimensions give you fine control over data definition and data hierarchy
  • With dimensions, you can customize financial reports around specific business activities, get greater visibility into how the business is doing, and make faster, more meaningful business decisions.
    Think of dimensions as a more powerful alternative to subaccounts.
    Additional fees can apply for the Project dimension and user-defined dimensions. Contact your account representative for more information.
  • Select Save.

Examples

About transferring funds between entity banks with differing currencies

The following table lists examples of permissible multi-currency fund transfers using USD and Euros, including transfers from:

  • Checking account to checking account
  • Checking account to savings account
  • Savings account to checking account
  • Savings account to savings account
  • Single currency

You cannot edit a funds transfer. However, you can reverse a funds transfer and then enter another with the correct information.

Cannot reverse a funds transfer?

You cannot reverse a funds transfer that has been included in a reconciliation. In this case, first reopen the reconciliation and then reverse the transaction. If you reconciled both bank accounts involved in the transfer, reopen the reconciliation for each of those accounts. If you used a funds transfer to pay off a credit card before 2019 Release 3, you cannot reverse the funds transfer.

  • Go to Cash Management > All > Funds transfer.
  • Find the funds transfer and select Reverse.
  • In the Reverse the transaction on date field, select the date for reversing the payment.
    This is usually the original transaction date or a later date.
  • Include an optional Memo for the reversal.
    The text you include here’s added to the original description, if one was included.
  • Select Submit.

After you submit the reversal, Intacct reverses the funds transfer and you return to the Funds transfers list. When a funds transfer reversal is waiting to reach the reversal date, the word Reversal appears in the list instead of the Reverse link. Funds transfers that were reversed are indicated by the word Reversed.

Can I undo a funds transfer reversal?

Undoing a reversal isn’t in accordance with accounting best practices. Instead of undoing a reversal, perhaps one that was done by mistake, re-enter the original transaction, correcting any errors. This ensures that the original transaction, reversal, and new transaction provide a valid audit trail and are compliant.

What is GAAP compliance?

Generally Accepted Accounting Principles (GAAP) is an accounting standard. Set by the standards organizations Financial Accounting Standards Board (FASB), Governmental Accounting Standards Board (GASB), and Financial Accounting Foundation (FAF), GAAP ensures uniform and consistent financial reporting across governments, businesses, and nonprofit organizations. GAAP compliance works to make sure that financial reporting is transparent and adheres to well-defined rules. Sage Intacct adheres to these standards when creating workflows that help maintain GAAP compliance.

For example, some accounting software allows editing transactions in closed periods. Sage Intacct requires books to be reopened to make changes. This way, Sage Intacct ensures GAAP compliance, an accurate audit trail, and complete historical reporting.

Funds Transfers list

View a list of funds transfers. From this list, you can perform the following actions:

  • View and edit the details of an editable transfer.
  • Drill down into the details of a non-editable transfer.
  • Reverse a funds transfer.

Trying to pay off a credit card balance? Funds transfers to or from a credit card are not supported. Instead, go to the Charge payoff page to create a bill for the charges and pay it on the Pay bills page.

  • Go to Cash Management > All > Funds transfer.
    When you access the list from the top level, you initially only see records created at the top level. To see records created within entities, select Filters and then select Include entity records. Select Apply to update the filter.
  • Find the funds transfer that you want to view.
  • Select
  • More actions
  • > View at the end of the row.

Check out our Free Additional Articles