Using Manual Deposits in Sage Intacct

Keywords:  Reports , Account Payable, Invoices, 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!

Manual Deposits

You can use a manual deposit to record receipt of money that’s not related to an invoice (for example, an over-the-counter cash sale). Matching invoices are automatically created.

Create a manual deposit

  • You have received a customer payment that was not made against an existing invoice, like an over-the-counter payment.
  • You have already made the deposit, and you are recording the details after the fact.

When you create a manual deposit, Intacct generates a corresponding invoice. Manual deposits automatically post to the General Ledger and appropriate subledgers. Manual deposits can be viewed and reversed, but not edited or deleted. If a customer payment is made against an invoice, record the deposit in the Receive payments page instead (Accounts Receivable > All and select “Add”

beside Receive payments – New!). You need an existing invoice to receive payments from a customer.

Enter deposit information

  • Go to Accounts Receivable > All > Payments > Manual deposits, and select Add.
    Is your organization configured with a single base currency among all entities, or multiple base currencies? If you use a single base currency, you can create manual deposits at the top level or entity level. With multiple base currencies, you can only create manual deposits at the entity level.
  • Enter or select the Customer ID for the customer from whom you’ve received payment.
    The Bill to and Ship to fields automatically populate based on the customer record.
  • Enter the Date on which you made the deposit at the bank, or accept the default of today’s date.
  • Specify the Bank where you made the deposit (or where you intend to make the deposit).
  • Enter the Invoice number generated for this customer.
  • For the Deposit ID, enter the information you need to correlate this record in Sage Intacct with the actual deposit slip from the bank.
  • If you have already made the deposit, this ID would be the transaction number on your bank deposit slip.
  • If you have not yet made the deposit, this ID can be a note such as “Deposit Slip of MM/DD/YY,”. This format is the default that Intacct suggests.
  • Add an optional Description.
  • To store a digital version of a supporting document, in the dropdown next to Attachment, select an attachment, or select Add, and 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.

Enter line item information

  • (Optional) Select default information for all line items.
    In the Entries section, you can add values directly to each line item, or select Show defaults to define default values to autofill each line item. To set up a value as a default for each existing and new line item, select the dropdown beside the appropriate field and choose a value. You can override any default value on any line item.
    For example, you can set dimension values for tracking and reporting purposes. After you select the GL account in the Items area, any dimension value that you set as a default is reflected for each line item.
  • 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.
    Remember to select Apply defaults to save your selections. See Set default line items for more information.
  • Enter line items in the manual deposit.
    In order for the deposit to be posted, you must specify at least the account and an amount for each line item. Depending on your company, you might be required to enter other information, such as the department or location. Also, depending on how your company is set up, you can drill down to the detail level in line items to enter additional information.
  • Select an Account or Account label to receive the income.
  • Enter the item Amount.
    Add negative line items to account for credits or discounts.
  • Enter a Memo for line items that might need reference information in the future.
  • Select Department and Location dimensions to assign each line item to a specific department or location.
  • If you use additional dimensions, such as customer, employee, or, class, project, or item, and want to assign the income to them, select Show details. Select the corresponding dimension dropdown and then select the specific dimension choice you want.
  • You have two options when you finish entering the manual deposit information:
  • Select Save to save the deposit and return to the list of manual deposits.
  • Select Save and new to save the deposit and add another.

View manual deposits

You can view details about all your manual deposits in the Manual Deposits page. The Manual Deposits page displays a list of payments that were recorded as manual deposits in your company. (Until you add a manual deposit, no line items appear on this page.) You can also use this page to view the details of a particular manual deposit.

Manual deposits can be viewed and reversed, but not edited or deleted.

  • Go to Accounts Receivable > All > Payments > Manual deposits.
  • To view the details of a deposit, find the deposit and select View.

You can also use the Manual Deposits page to drill into the summary in which a particular manual deposit belongs. Drilling into the summary allows you to examine other manual deposits in that summary. To view credit cards at the top level, select Include private in the Credit Card Accounts list. The items on this page vary slightly depending on whether your company is an enterprise or a multi-entity shared company. If your company is a multi-entity shared company at the top level, you initially see only the items that were created at the top level. To see items created in the entities, select the Include private checkbox. Also, when you edit an item that was created in an entity, your changes apply to that entity. After you save your changes, you are returned to the top level.

When you select a custom view, some options are hidden. Depending on the page you’re on, the Include inactive, Include one-time use, Include private, and Display hierarchy options are not visible. For example, if you’re viewing from a custom view, the Financial Reports list will not provide the Include inactive option.

Reverse a manual deposit

You can reverse a manual deposit from one of two places: the receipts register report or the payment summary of the manual deposit. Manual deposits can be viewed and reversed, but not edited or deleted.

Reverse from the Receipts Register

You can correct an erroneous manual deposit by going to the receipts register, finding the entry you want to correct, and reversing it.

By using the receipts register to correct a manual deposit, you keep your reconciliations clean and clear.

  • Go to Cash Management > All > Reports > Registers, and select Receipts.
  • Run a receipts register report.
  • Find the entry that you want to reverse in the receipts register, and select Reverse at the end of the entry.
    The Transaction Reversal Date page appears.
  • Select the date for reversing the transaction.
    This date is usually the original transaction date or a later date.
  • Select Submit.
    The Receipts Register page removes the Reverse link and tags the entry as Reversed. Intacct adds an additional balancing entry, which it tags as Reversal.

Reverse from the payment summary

You can reverse payments that you misapplied and need to correct from the payment summary.

  • In the Payment summaries page, find the required summary, and select Payments.
  • Find the payment that you want to reverse and select Reverse.
  • Enter the following:
  • For Reverse the transaction on date, select the date for reversing the payment.
    This date is usually the original transaction date or a later date. You can even select a date from a prior closed period, so that your financial statements are correct.
  • For the Memo, add a description that applies to this line item.
    This text is for your information only.
  • To remove the invoices that were paid by this deposit, select the checkboxes in the Reverse column.
  • In the Transaction reversal date dialog box, select Submit.
    Intacct returns you to the Payments page. The Reverse link now is labeled Reversed.

View manual deposits in a summary

If your company uses summaries, you can view a list of manual deposits that are in a payment summary from the Payments page.

Manual deposits can be viewed and reversed, but not edited or deleted.

  • Go to Accounts Receivable > All > Subledger > Payment summaries.
  • Select a payment summary to view all the deposits in a particular summary or to reverse a payment.
    The Payments page details the manual deposits in a summary. For example, it shows you if the manual deposit has been fully applied to the invoices for that customer, or whether there’s more to apply. (If a customer overpays an invoice, you can select Apply more to apply the excess to another invoice or invoices.)

Reclassify an invoice associated with a manual deposit

You can edit certain fields in an invoice that has an associated deposit.

  • Go to Accounts Receivable > All > Invoices.
  • Select Edit beside the invoice associated with the deposit.
  • Edit the available fields according to your needs.
    You can only edit fields that are not for transactional data. Transactional data includes the customer, date, GL account, and transaction amount.
  • Select Post.

Difference between 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.

To receive multiple payments from a single customer, you need an existing invoice to apply the payments to using the Receive payments page. Is your organization configured with a single base currency among all entities, or multiple base currencies? If you use a single base currency, you can create manual deposits at the top level or entity level. With multiple base currencies, you can only create manual deposits at the entity level.

Check out our Free Additional Articles