Keywords: Bills, Account Receivable, Sage
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 – Customer Advances
Use Accounts Receivable advances to record an advance payment from a customer. If your company is a multi-currency company, you can create and calculate the advance in the received currency directly in Sage Intacct.
How advances differ from other payments
Ordinarily, you create an invoice before you receive a customer payment, so you can apply that payment to the invoice. However, you can use the Receive Advances page to receive a payment from a customer without having first created an invoice.
For example, use this page to record a prepayment or retainer. After the invoice is added, you can apply the advance credit to the invoice on the Receive Payments page. In shared multi-entity companies with multiple base currencies, you can receive and record advances at the top level and at the entity level. At the top level, you must include the base currency and the transaction currency.
Advances configuration options
You can see how customer advances are mapped to a specific GL account on the Configure Accounts Receivable page. From here, you can also set the summary frequency for batching advanced payments and enable foreign currency advance payments.
Receive advances
Receive a customer advance to be applied later to an invoice. If you reverse an advance to correct information, receive it again to replace the reversed advance.
- Go to Accounts Receivable > All > Payments and select
- Add
- next to Advances.
- How you receive the advance depends on your summary configuration settings for advances.
- If you’re configured for automatically batching payment summaries, select an Account type and Account to receive the advance.
- If you’re configured for user-specified payment summaries, select a Payment summary to receive the advance.
- About payment summaries
- The Payment summary groups payments together for deposit into the same account or into undeposited funds. The summary names in the dropdown list are the same ones that you see when you select Accounts Receivable > All > Subledger > Payment summaries.
If you have not already created a Payment summary, go to Accounts Receivable > All > Subledger > Payment summaries and add one.
When creating the payment summary, select the bank account into which the payment will be deposited. You can also select Undeposited funds for payments (such as cash and checks) that will be deposited later.
Select the Payment method by which the customer paid you.
- Choose the Customer ID of the customer from whom you received the advance.
- Enter the Receipt date and Payment date.
- The Receipt date is the date on which you received the check, cash, credit card, or bank transfer.
- The Payment date is the transaction date. If the payment was made by check, the payment date is the date printed on the check. If the payment was made by cash, the payment date is the date you received the payment. If payment was made by credit card, it’s the date on which the transaction occurred. If payment was made by bank transfer, it’s the date on which the transfer occurred.
- For check payments, it’s recommended that you record the check number.
- If you’re a multi-currency company and the advance is a different currency than your base currency, select the Transaction currency.
Enter other currency conversion details as appropriate, such as the exchange rate date, type, or rate itself: - Type or select a date for the Exchange rate date.
- In Exchange rate type, select the dropdown to select an exchange rate type such as Intacct Daily Rate, or WSJ Published Rate. If your company uses custom exchange rate types, you can see them listed here.
- If you know the exchange rate for this advance, you can enter it in Exchange rate to override system calculations.
- After you enter the Transaction amount for each line item, Intacct converts the amount to the transaction currency that you selected and displays it in the Base amount field.
Examples: - Your company base currency is USD, and your bank currency is also USD. You can receive and record advances in the transaction currency.
- Your company base currency is US dollars, and your bank currency is GBP. You can receive and record advances only in GBP.
- Multi-currency advances are not supported for undeposited funds accounts. Associate the payment summary or advance with a bank account, then try again.
- Optionally, add a Payment memo for future reference.
- Select or add an Attachment to store a digital version of a supporting document.
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
Now enter the line items for the advance that you defined.
- Select the GL offset account or Account label dropdown list to select a different account or account label.
This field displays the default offset account specified when Accounts Receivable was configured (Accounts Receivable > Setup > Configuration). You can overwrite this account by selecting another.
- In the Amount field, enter the amount of the advance payment for this line item.
You can only enter positive line item amounts for advances.
In a multi-currency company, Intacct displays Txn amount and Base amount instead of Amount. Tax Amount is the amount in the currency in which the payment was received and recorded. Base Amount is the amount in the base currency of your company. If yours is a multi-currency company, enter the Tax amount and Base amount.
- Optionally, in the Memo field, enter text to help you identify this line item.
- Optionally, select a Department and Location.
(These dimensions are primarily used for multi-entity companies.)
- Optionally, you can select a Dimension for each line item. Select Add to select a dimension to associate with the line item: Project, Customer, Item, Employee, or Vendor.
- 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. Repeat steps 1 through 5 for as many line items as you need.
- Select Save.
Apply an advance to an invoice – Accounts Receivable
Apply an advance payment to a customer invoice from the Receive Payments page or the Advances list. You can apply the full amount of the advance or a partial amount. You can also apply the advance to multiple invoices.
Apply advances from Receive Payments
- Go to Accounts Receivable > All > Invoices and select
- Add
- next to Receive payments – New
- In the Payment information section, enter the Receipt date, when the advance will apply to the invoice.
- Select Select invoices.
- Filter for and add the invoice in the popup.
- Select Available credits and select the advance from the list of available credits.
- Select Save.
The full amount appears in the Credits to apply column and the Payment amount automatically adjusts accordingly.
If you do not want to apply the full amount, you can adjust the amount in the Credits to apply field.
- Select Post.
Apply an advance from the Advances list
You can apply a single advance to invoices from the Advances list.
- Go to Accounts Receivable > All > Payments and select Advances.
- Select Apply more next to the advance you want to apply.
The Select Invoices for Payment page pops up with all open invoices for the associated customer.
- Select the invoices you want to apply the advance to, then select Add and close.
- The advance amount is applied to the selected invoices using the waterfall payment method.
You can adjust the amount to apply in the Credits to apply field.
- Select Post.
View and edit a customer advance
You can view and edit specific advances from the Advances list. The Advances list shows all customer advances and the amount left to apply for each.
View an advance
Posted advances include all check payments, and any off-line transactions that are fully approved (credit card, electronic funds transfer, cash, or online credit card). In a top level company, you initially see only items that were created at the top level. To see items created within entities, select the Include private checkbox.
- Go to Accounts Receivable > All > Payments > Advances.
- Select View next to the advance you want to view.
Edit an advance
You can only edit advances that have not been applied to an invoice. If an advance was applied to an invoice and later unapplied, it’s unavailable to edit. The General Ledger account book must also be open.
- Go to Accounts Receivable > All > Payments > Advances.
- Select Edit next to the advance that you want to edit.
- Make your changes.
- Select Save.
Reverse a customer advance
You can reverse advances from the Advances list. After an advance is applied to an invoice, it can’t be reversed. 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 > Advances.
- At the end of the appropriate row, select Reverse.
The Transaction Reversal Date pop-up appears.
- In the Transaction Reversal Date pop-up, enter the following:
- In Reverse the transaction on date, select the date for reversing the advance.
This date can be the payment summary date or a later date. You can even include 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 of the check.
This text is for your information only.
- Select Submit.
The Advances list appears, and you can see two line items for this transaction. (The transaction is not zeroed out so there’s an audit trail.) - One line item is the original transaction, where the Reverse link now is labeled Reversed.
- The other line item added by Intacct is the reverse transaction, which produces a net effect of zero. This transaction is labeled Reversal.
For example, you have an advance for $10. After reversing, you still have the original $10 advance, but also a transaction for -$10, resulting in a net of zero.
Next step: If you reversed the advance to correct it, receive a new advance with the corrected information.
Check out our Free Additional Articles

