Keywords: Invoices, Account Receivable, Recurring, 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!
Recurring invoices—Accounts Receivable
Recurring invoices are invoices that repeat at periods and durations that you define in the recurrence schedule. Intacct respects your company’s accounting periods to generate and post transactions based on your defined month end.
Create a recurring invoice
Enter invoice information
- Go to Accounts Receivable > All > Invoices and select
- Add
- next to Recurring invoices.
- Select a Customer.
The Bill-to and Ship-to fields automatically populate when you select an existing customer. You can override these defaults as needed. - Select or add an Invoice sequence number to include an invoice number.
You can use the invoice number to search, sort, and report on invoices. - If this recurring invoice is part of an ongoing contract, enter the Contract ID for the contract.
To include a description of the contract, enter the information in the Contract description.
Enter transaction details
- Select or add a Payment term for the recurring invoice.
- To assign a transaction allocations template, select Allocation, then select the appropriate template.
- Add an Attachment to store a digital version of a supporting document.
Enter currency information
- Select a Transaction currency.
- If the transaction currency is not your company’s base currency, select an Exchange rate type.
See Exchange rate types for information. - Enter an Exchange rate if you know what the exchange rate is for this invoice or have contracted a set rate with the customer.
Otherwise, Intacct generates the exchange rate with each invoice.
Enter line item details
- Select a GL account or Account label to receive the invoice.
- Enter the item amount in Amount.
- For companies using multiple currencies, enter the Transaction amount, which is the amount in the transaction currency. Intacct then calculates the Base amount in your company’s base currency according to the exchange rate listed in the header.
- 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.
Use the Payment tab to set up payments for the recurring invoice.
Establish the recurrence schedule
- Go to the Schedule tab.
Select a Start date for the first date on which the invoice will be generated. - For Repeat, select the frequency in which the invoice will recur.
- Select None to have the invoice occur only once.
You might want to select this option if you’re setting up an invoice for an item that might be recurring, like a 30-day trial. Later, you can choose to change the schedule if the service becomes an ongoing expense. - Select Days, Weeks, Months, or Years to have the invoice occur at regular intervals, then enter the number of intervals in the corresponding field.
For example, if an invoice occurs every other month, select Months and enter 2. If you select a time period but do not enter a number, Intacct defaults to 1.
For weeks, months, and years, the invoice will recur at the next interval on the same date as the start date. For instance, if you set an invoice to start on the 15th of the month and recur monthly, Intacct generates the invoice each month on the 15th. To make an invoice with a monthly interval generated at the end of the month, select End of month. - For Ends, select the appropriate termination point for this invoice.
- To keep the invoice perpetually running – select Never.
This option is common for invoices like ongoing services that have a set price. - To have the invoice run for a limited number of times – select After _ occurrences and enter the number of times the invoice will recur.
This option is often used for debts that are being paid over time. Setting the number of occurrences eliminates the possibility of making payments after the debt is paid off. - To have the invoice recur until a specific date – select On _ and enter an end date.
You have two options when you finish entering the invoice and schedule information:
- Select Save to save the invoice and return to the list of invoices.
- Select Save and new to save the invoice and add another.
Set up payments for a recurring invoice
Use the Payment tab of a recurring invoice to set up how Intacct processes payments from the customer. You can set the payment method to automatically process payments. Intacct automatically fills in the Customer and Term fields.
Leaving the payment method set to None allows Intacct to process the invoice through your normal Accounts Receivable collection cycle.
Intacct processes payments for recurring invoices on the same date that it generates the invoice.
Set up offline payments—Cash, Check, Credit card, Record transfer
- Go to Accounts Receivable > All > Invoices > Recurring invoices.
- Find the recurring invoice that you want to set up payments for.
- Select Edit.
- On the Payment tab, select Check, Credit card, Record transfer, or Cash as the Payment method.
After you select a payment method, Intacct displays additional fields related to that method. - If the payment method is credit card, select the Card type.
- Select the Account type.
- Select Pay in full or clear the selection and enter a partial Payment amount.
When payment is made, note the following: - Payment is attempted at the time the recurring invoice is generated.
- Credits are not applied to payments made against recurring invoices.
- Term discounts are not applied to partial payments.
- Depending on the payment amount, the Payment status changes to either Paid or Partially paid after a successful payment attempt.
- Select the Bank account or Undeposited funds account where you want Intacct to post the payment.
- Select Save.
Set up online payments—ACH debit, Credit card
If Intacct cannot generate an invoice, it will not generate a payment.
- Go to Accounts Receivable > All > Invoices > Recurring invoices.
- Find the recurring invoice that you want to set up payments for.
- Select Edit.
- On the Payment tab, for the Payment method, select Online ACH debit or Online credit card.
Intacct displays additional fields to specify how you want to account for the payment. - Select the Credit card/Customer bank account dropdown, and select the customer payment item to be used in this transaction.
- Select the Account type dropdown, and select the account type, Bank or Undeposited funds account, to which you want to post the payment.
- Select Pay in full or clear the selection and enter a partial Payment amount.
When payment is made, note the following: - Payment is attempted at the time the recurring invoice is generated.
- Credits are not applied to payments made against recurring invoices.
- Term discounts are not applied to partial payments.
- Depending on the payment amount, the Payment status changes to either Paid or Partially paid after a successful payment attempt.
- Select the Bank account dropdown, and then select the account to which you want to post the payment.
This field is required when using an undeposited funds account. - Select Save.
Intacct captures successful and failed electronic payment attempts in the Electronic Payment list.
View and edit a recurring invoice
View a recurring invoice
You view details about a recurring invoice from the Recurring Invoices list
- Go to Accounts Receivable > All > Invoices > Recurring invoices.
Only a few of the specific details for a record can be shown in the list columns.
Select View. The record details appear. If the record is complex, the details are categorized into sections and tabs. - To view a recurring invoice in detail, find the invoice.
- Select View.
Edit a recurring invoice
You edit information about an invoice from the Recurring Invoices list.
- Go to Accounts Receivable > All > Invoices > Recurring invoices.
- Find the invoice that you want to change.
- Select Edit.
- Make your changes.
- You have two options when you’re finished:
- Select Save to save the invoice and return to the list of recurring invoices.
- Select Save and new to save the recurring invoice and add another.
Turn a recurring invoice schedule on or off
You can turn on or turn off a recurring invoice schedule as needed. For example, if a contract is temporarily put on hold, you can turn off a schedule to stop Intacct from automatically creating invoices.
When you are ready to restart the recurring schedule, you can turn the schedule back on.
- Go to Accounts Receivable > All > Invoices > Recurring invoices.
- Make sure Include inactive is selected.
This option allows you to see all recurring invoices and not just active ones. - Find the row associated with the schedule, and select one of the following:
- Turn on to activate the schedule.
- Turn off to deactivate the schedule.
When you turn off a schedule and then turn it on again at a later date, the system resumes the recurrence schedule from the turn-off point. If periods were closed in the meantime, the system generates an error message as it tries to create recurrences in each of those closed periods. As soon as it reaches an open period, the system generates those recurrences to the turn-on date.
If you want to turn on the schedule and have the system generate recurrences from a later date, first edit the Next execution date in the recurring schedule.
Check status and retry recurring invoices
You can view the status of scheduled recurring invoices in two ways, either by generating the Recurring transaction status report, or by viewing the execution log from the Recurring invoices list.
- Recurring transaction status: Run this report when you want to evaluate the run status of multiple recurring invoices and retry failed invoices.
- Execution log: View this when you want to drill down into the status of a single scheduled invoice directly from the Recurring invoices list.
View status for multiple scheduled invoices and retry failures
Run the Recurring transaction status report to see whether scheduled recurring invoices were successfully created. You can retry failed jobs or drill down for more information from the report results.
- Go to Accounts Receivable > All > Reports > Recurring transaction > Status.
- Select a Reporting period.
- In Filters, select AR invoices as the Transaction type.
- To exclude successfully generated runs, select Show failed only.
- Select View to generate the report.
Sage Intacct displays the recurring transactions that were scheduled to run during the reporting period.
If the report does not return any results
- You might not see any recurring invoices in the following circumstances:
- No transactions were scheduled to recur during the time period you selected.
- You selected Show failed only and all scheduled jobs during this time period were successful.
- You are viewing the top level and the transactions were created at the entity level.
- For failed recurring transactions, select View error to open the error log.
- To try a failed invoice run again, select Retry.
If this generates an error, investigate the problem, then edit the recurring invoice to fix it. Go to Accounts Receivable > All >Invoices > Recurring invoices. - Select the entry in the Last result column, either Failed or Success.
This opens the Execution log for the most recent run of the invoice schedule. Each run for a recurring invoice typically generates two log items: - In transit: The recurring invoice process is initiated.
- Success or Failure: The end result, where success means that the recurring invoice was created.
- If the run failed, select Failure in the Execution status column.
Use the Log created on date and Transaction date fields to help you determine for which log entry you want to view the error details.
The error log opens to show details about the error. - To create a PDF of the error log, select Print to… > View and download as a PDF file.
- For successfully recurring invoice runs, select View invoice to see the invoice that was created.
- Select the number in the Rec doc column to drill down to the recurring invoice template.
If you have edit permissions for recurring invoices, you can select Edit and modify the template.
Delete a recurring invoice
If there’s no chance you’ll use a recurring invoice anymore, you can delete it instead of turning off the recurring schedule. For example, if you’ve permanently canceled a contract with a customer, you can delete the recurring invoice that was set up for that customer.
- Go to Accounts Receivable > All > Invoices > Recurring invoices.
- Find the record that you want to remove.
- Select Delete.
- Confirm your delete action.
Intacct removes the recurring invoice from the Recurring Invoices list and creates no more invoices.
Write off unpaid invoices as bad debt
If your customer owes a positive balance but payment is not likely to be forthcoming, you can adjust their account to zero out the balance.
- Create a credit memo for the unpaid amount.
- Apply the credit memo to the unpaid customer invoice.
The invoice and the adjustment will no longer display on your aging report.
Check out our Free Additional Articles

