What to know about AP Summaries in Sage Intacct

Keywords: Transactions, Bills, Account payables, 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!

About AP summaries

Summaries are collections of the same type of transactions, grouped together and posted to the General Ledger using the date determined by your summary frequency. The individual transactions in a summary are processed immediately. The Summaries page in Accounts payable shows bill, adjustment, and manual payment summaries that Intacct created automatically or that you created manually. Until you or the system creates a new summary, no line items appear in the Summaries list page. Summaries can be either opened or closed. When summaries are open in Accounts Payable, you can add and pay bills. When designing an accounts payable process, the system administrator can give access to the pages involved with managing bills, but not opening or closing summaries.

You can reopen closed summaries as needed.

Closing or opening a single summary doesn’t automatically close or open related summaries in the subledger period. To open or close related summaries, go to the Open AP Subledger or Close AP Subledger pages respectively.

How summaries are created

Summaries for bills are created in two ways:

  • Automatically, by Sage Intacct at intervals you select
  • Manually, by specific summaries you create and name to handle special situations

Automatically created summaries

Sage Intacct can automatically create summaries so that a summary always exists for bills and other payments as they are entered throughout the day. Automatic summaries are created according to intervals chosen by the administrator, such as daily, monthly, or one per transaction. Automatically created summaries are not editable. You set the frequency of automatic summary creation on the Configure Accounts Payable page. Transactions are posted in real time, regardless of the summary frequency you select. The summary frequency determines how transaction postings are grouped in the General Ledger, rather than when they are posted.

Intacct uses the internationally accepted date format of YYYY-MM-DD for all automatically created summaries. Using a standardized date format in the summary title ensures that transactions are always grouped or matched to the appropriate summary. This removes the risk of posting errors due to a date format mismatch.

Manually created summaries

A manual summary is useful when you need a special summary for specific bills. You can use whatever date format your company prefers when you enter a summary manually. If you have a list of transactions saved in CSV (comma-separated values) file format, you can import it to Intacct. When you specify a BATCH_TITLE for an imported transaction, Intacct creates a summary named using the title and the CREATED_DATE, then assigns the transaction to the summary. You can also add a transaction to a manually created summary during data entry, when the Summary frequency for that transaction type is set to User-defined. This option is available for bills, adjustments, and manual payments.

Manually created summaries are editable.

Multi-entity, multi-currency companies

If your company is a multi-entity, multi-currency company, Intacct recommends you set the system to create summaries automatically, so that the system creates consistent summaries with the correct base currency. If you create manual summaries, create them at the entity level, or restrict one summary to one entity so that the summary contains one currency. Do not create top-level, manual summaries.

Open a summary—Accounts Payable

If your organization’s policies allow it, you can re-open a closed summary to allow changes such as adding or deleting bills. The Open AP subledger page enables you to reopen summaries either by period or by summary name. Opening a single summary does not automatically open related summaries in the subledger period.

Re-open a summary

  • Go to Accounts Payable > All > Subledger > Open.
  • If you are at the top level, select an Entity or entity group.
  • You have two ways to open summaries:
  • By date: select To the start of period, then select a standard period such as Month Ended January 2020, First Quarter 2020, and so on. Sage Intacct opens both bill summaries and adjusting summaries.
  • By name: select Open a single summary, then select the name of the summary you want to open.
  • Select Open.
    Are you opening the summary to post a single transaction? Remember to close it immediately so no one can inadvertently post more transactions to it.

Field descriptions

The following table describes each item in the Open summaries fields:

Close a summary—Accounts Payable

From the Close AP subledger page, you can close an open summary either by period or by summary name. Closed summaries can later be reopened. Summaries of manual payments are automatically closed. After you close a summary, you cannot post transactions to it until you reopen it. This prevents you from posting transactions to the wrong period. (The system uses the summary date as the posting date for almost all transactions.)

Closing a single summary doesn’t automatically close related summaries in the subledger period. To close related summaries, go to the Close AP subledger page.

  • Go to Accounts Payable > All > Subledger > Close.
  • If you are at the top level, select an Entity or entity group.
  • You can close summaries in one of two ways:
  • By date: select To the end of period, and then select a standard period such as Month Ended January 2013, First Quarter 2013, and so on.
    The system closes both bill summaries and adjusting summaries.
  • By name: select Close a single summary, and then select the name of the summary you want to close.
  • When you close a subledger for a period, the system does not close open subledgers from previous periods. For instance, if you close subledgers for Q3 and have not closed Q2, Q2 remains open.
  • Select Close.

Field descriptions

Create a manual summary—Accounts Payable

Summaries are collections of the same type of transactions, grouped together and posted to the General Ledger using the date determined by your summary frequency. The individual transactions in a summary are processed immediately. The summary frequency that you select for a transaction type in your configuration determines whether Sage Intacct creates summaries for you automatically. If your Accounts Payable summary frequency for bills, adjustments, or manual payments is set to User-specified, you need to create manual summaries. If your summary frequency is daily, monthly, or once per transaction, Intacct creates the summaries for you automatically. When you enter a bill, adjustment, or manual payment, and your summary frequency is User-specified, you can select the summary that you want to add the transaction to. Only open summaries appear in the list for the Summary field. If you do not see the Summary field during data entry, verify that the summary frequency is set to User-specified for that transaction type.

Sage Intacct recommends that you configure your Accounts Payable application for automatic summaries (daily or monthly).

The summary date is the date the General Ledger uses to post all transactions within that summary. Therefore, it is important that you don’t combine transactions from different time periods within the same summary. Also, note that summaries are posted automatically to the GL once transactions within those summaries are saved. You can edit or delete a bill within a summary at any time before making a payment on that bill.

  • Go to Accounts Payable>All > Subledger >Summaries.
    The summary list appears.
  • Select Add.
    The system displays the Summary information page.
  • In the Summary title, type a name for the summary.
    Intacct uses this name to identify the summary throughout your Accounts Payable application.
  • In GL posting date, type or select the date you want the items in this summary to post to the general ledger.
    Intacct autofills the current date, but you can change it.
  • To deactivate (or close) the summary, select Status, then select Inactive.
    Otherwise, leave Status set to Active.
  • In Summary type, select the type of items you want this summary to contain:
  • Bill
  • Adjustment
  • Manual payment
  • Select Save.
    The summary you just created is a manual summary even if the auto-summary feature is on.

Select a summary name to add items to it for summary processing. For example, after adding Adjustments Summary, select Adjustments Summary to add adjustments.

Field descriptions

The following table describes each item in the Summary information page:

Delete a summary—Accounts Payable

You can delete a summary when:

  • The status is open
  • The summary does not contain any transactions

See Open an AP summary and Delete a transaction from summary—Accounts Payable for instructions on opening a summary and deleting its contents.

  • Go to Accounts Payable > All > Subledger > Summaries.
  • Select Delete next to the summary you want to remove.
  • Select OK to confirm your action.

View a summary—Accounts Payable

Use the Summaries page to view a list of all manual and automatically created summaries for bills, adjustments, and manual payments. You can sort and filter this list to see just the summaries you want. You can also drill down to view the transactions contained within a summary.

  • Go to Accounts Payable > All > Subledger > Summaries.
    The Summaries page opens, showing a list of active bill, adjustment, and manual payment summaries. To view items with a Status of Inactive, select Include inactive.
    If you’re viewing items from a top level company, you only see items created at the top level. To view items created at the entity level, select Include private.
  • To view information about a summary, select View next to the summary.
    The summary information page shows the Summary title, GL posting date, and Status.
  • To view the transactions contained within a summary:
  • Select the Summary name.
    The system displays a list of records included in that summary. You can add, edit, or delete records in the list as you would any list of bills, manual payments, or adjustments.
    If you add a record in the summary contents list, the system automatically adds it to that summary.
  • Select View next to a transaction to view details.

Edit a summary—Accounts Payable

Change the details of a manual Accounts Payable summary from the Summaries page. Summaries that Sage Intacct creates for you are not editable.

You can edit the summary title, GL posting date, and status.

  • Go to Accounts Payable > All > Subledger > Summaries.
  • On the Summaries list, select Edit next to the appropriate summary.
  • Make your changes.
  • Select Save.

Add a transaction to a summary—Accounts Payable

You can add a bill or an AP adjustment to an open summary of the same type, directly from the page where you view the summary contents. Transactions you add to a summary appear in either the Bills list or the AP adjustments list, based on the type.

  • Go to Accounts Payable > All > Subledger > Summaries.
  • Select the Summary name for the summary you want to edit.
    A list of the summary contents appears.
    You can add a transaction to a summary as long as it is open. The transaction type for the summary must match the transaction type you want to add.
  • Select the Add button.
    The Add page for the transaction type, either Bill or AP adjustment, appears.
  • If you do not see the Add button
  • Verify the following:
  • The summary is open
  • You have Add permissions for the transaction type
  • Enter the transaction details.
  • Select Post or Submit.

Delete a transaction from summary—Accounts Payable

You can delete the following transactions from open AP summaries:

  • An unpaid bill that has a state of Draft, Posted, or Declined, provided your company is not enabled for reversals
  • A debit memo adjustment (vendor credit) that has not been applied to a bill
  • A credit memo adjustment that has not been paid or selected for payment

For all other bills and adjustments, reverse the transaction instead.

Deleting a transaction from a summary removes it from the system completely. This action cannot be reversed.

  • Go to Accounts Payable > All > Subledger > Summaries.
  • Select the Summary name for the summary you want to edit.
  • Select the Delete link next to the transaction you want to remove.
    If the summary contains multiple transactions, select the transaction and then select Delete.
  • If you do not see the Delete option for bills
  • You can delete an unpaid bill when:
  • You have Accounts Payable permissions to delete bills.
  • Your company is not enabled for reversals.
  • You are a Business user type.
  • There are no payments made against the bill.
  • The bill isn’t the result of a charge payoff.
    In this case, reverse the bill.
  • The bill hasn’t been reconciled.
    After a bill has been reconciled, you can no longer delete or reverse it. Instead, reopen the reconciliation to make changes.
  • For a bill in an Approved state, you can only delete the bill if there isn’t a payment made against it.
    For a bill in a Selected or Partially Paid state, cancel the associated payment request, then delete the bill.
  • If you do not see the Delete option for adjustments
  • You can delete an adjustment when:
  • The adjustment is a credit memo that has not been paid or selected for payment.
  • The adjustment is a debit memo (vendor credit) that has not been applied to a bill.
  • The transaction has not been reconciled.
    After a transaction has been reconciled, you can no longer delete or reverse it. Instead, reopen the reconciliation to make changes.
  • You are a Business type user.
  • You have Accounts Payable permissions to delete adjustments.
  • For credit memo adjustment in a Selected state, cancel the associated payment request, then delete the adjustment.
  • Select OK to confirm your action.
    Intacct removes the transaction from the summary and from the system.

Reverse a bill in an Accounts Payable summary

You can reverse an unpaid bill from an open AP summary, if your company is enabled for reversals. After you reverse a transaction, the state changes to Reversed. Intacct also adds a reversing transaction to the system, which you can view on the Bills list. This new transaction has an amount that reverses the original transaction and has a state of Reversal. After you reverse a transaction, you cannot undo the reversal. However, you can create another transaction to replace the original.

Reverse an unpaid bill from an AP summary

You can reverse an unpaid bill if you enable reversal of unpaid bills in Accounts Payable configuration, or if the bill is the result of a charge payoff. Otherwise, delete the bill. You can’t reverse a declined bill. Instead, submit the bill again for approval and approve it. This puts the bill in a Selected state, and you can then reverse it.

  • Go to Accounts Payable > All > Subledger > Summaries.
  • Select the Summary name for the summary you want to edit.
  • Select Reverse next to the appropriate bill.
  • You can reverse an unpaid bill if:
  • You have Accounts Payable permissions to reverse bills.
  • The bill is in a Draft or Posted state and your company is enabled for reversals.
  • The bill has not been reconciled.
    After a bill has been reconciled, you can no longer delete or reverse it. Instead, reopen the reconciliation to make changes.
  • On the Transaction Reversal Date page, enter a:
  • Memo: As a best practice, enter the reason for the reversal.
  • Reversal date: To keep your aging reports balanced, enter the original transaction date.
  • Select Submit.

Reverse a paid bill from an AP summary

To reverse a paid bill, first void the associated payment in the appropriate register. When you void the payment, you can reverse the associated bill at the same time. Alternatively, you can reverse the bill on the Bills list following the instructions below.

After a bill has been reconciled, you can no longer delete or reverse it. Instead, reopen the reconciliation to make changes.

  • Go to Accounts Payable > All > Payments > Posted payments.
  • Filter the columns to find the payment you want to void.
  • Select Void next to the entry.
    If you can’t select Void, the payment might already be voided.
  • In Void the payment on date, enter the date when the payment should be recorded as voided.
    To keep your aging reports balanced, enter the original transaction date.
    After you select Submit, you cannot edit the void date.
  • In Memo, describe the reason you are voiding the payment or provide reference information.
  • On the bottom of the page, select the Reverse checkbox next to the payment.
  • Review the void and reversal dates, and add a memo.
  • Reverse as of: To keep your aging reports balanced, enter the original transaction date.
  • Memo: As a best practice, enter the reason for the reversal.
  • Select Submit.

Field descriptions: Accounts Payable Summaries

The following tables list each field on the Accounts Payable Summaries list and the summary page.

Summaries List

Buttons

Links

Columns

Summary Page

Check out our Free Additional Articles