About deleting and reversing bills in sage Intacct

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

Learn the differences between deleting and reversing a bill, and the conditions that determine which option is available.

Differences between delete and reverse

Reversing a bill provides an audit trail for the transaction.

Requirements to delete or reverse a bill

Whether you see the delete or reverse option is impacted by:

  • Where the bill is within the Accounts Payable workflow
    For example, whether it is paid or unpaid, in approval, or reconciled.
  • How your company is configured
  • Your user permissions

Unpaid bills

You can delete an unpaid bill if;

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

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.

Paid bills

You can’t delete paid bills, you can only reverse them.

You can reverse a paid bill if;

  • You have Accounts Payable permissions to reverse bills.
  • You are a Business user type.
  • 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.

Reverse or delete based on bill state and configuration

Determine the action that you can take on a bill based on its state and how Accounts Payable was configured.

After you reverse a transaction, you cannot undo the reversal. However, you can create another transaction to replace the original.

Reclassify a bill in Accounts Payable

To update a bill that is in a Selected, Partially paid, or Paid state, you need to reclassify the transaction. Only authorized users can reclassify a transaction and the option to reclassify must be enabled for your company.

Only some fields can be edited when you reclassify a transaction. For example, you can change the account and location dimension for a line item, but you cannot change the amount or add and remove line items.

  • Go to Accounts Payable > All > Bills.
  • Find the bill that you want to reclassify.
    The bill state must be Selected, Partially paid, or Paid.
  • Select Edit next to the bill.
  • Select Reclassify.
  • If you do not see the Reclassify button, it is usually for one of the following reasons:
  • You do not have reclassification enabled in the application configuration.
  • You have not been granted the appropriate permissions to reclassify this transaction type.
  • The transaction is unpaid and you need to edit it instead.
  • The transaction state is Reversed or Reversal and cannot be reclassified.
  • You are trying to reclassify a transaction type that does not support reclassification.
  • Make your changes.
  • What information can I reclassify?
  • Bill number
  • Account number
  • Line item dimensions, such as Location or Department
    Location and Department cannot be edited for lines where an allocation is selected.
  • 1099 fields, if the vendor is already set up for 1099 reporting
  • Term, Due date, and Payment priority
  • Reference number, Description, Attachments, and Memo fields
  • Select Post.

Place or release a bill on hold

You can place a bill on hold to exclude it from the Pay bills list and prevent it from being paid. For example, you might want to place a bill on hold if the dollar amount is wrong, or your company is disputing the bill, or you simply didn’t receive the goods.

After the issue is resolved, you can release the hold. The bill is included in the Pay bills list, if it is posted.

Are you using bill approvals? When you edit a posted bill to add or remove a hold, the bill is submitted for approval.

Place a bill on hold

  • Go to Accounts Payable > All > Bills.
  • Select Edit next to the appropriate bill.
  • On the Transaction tab, select Place this bill on hold.
  • Select Submit or Post.

Release a bill on hold

  • Go to Accounts Payable > All > Bills.
  • Select Edit next to the appropriate bill.
  • Deselect Place this bill on hold.
  • Select Submit or Post.

Cannot place a bill on hold?

For bills in the following states, you need to take an additional step before you can place them on hold.

View and manage bills from the Bills list in Accounts Payable. From there, you can drill down into bill details, where you can view the transaction history and see how it posted to the General Ledger.

  • Go to Accounts Payable > All > Bills.
    If you’re viewing payments from a top level company, you only see bills created at the top level. To view transactions created at the entity level, select Include private.
    The State column shows where the bill is within the workflow. Learn more about bill states.
  • What actions can I take from the Bills list?
  • From the Bills list, you can:
  • Sort and filter bills
  • Import from a CSV file
  • Export a list
  • Print a copy of a bill
  • Delete or reverse a bill (depending on your configuration)
  • Recall a bill that was submitted for approval
  • View an attachment by selecting the
  • Attach
  • , in standard views
  • Edit or view a bill
  • Filter the list to find specific bills.
    You can use simple filters at the top of each column, advanced filters, or create a custom view. If you create a custom view, you can add additional fields and arrange them to suit your preference.
  • Select View next to a bill to see details.
  • View the attachment side-by-side with bill details
  • To view a bill attachment alongside bill details, customize your user preferences to enable Personalize split view. Select both Enable split view and Show split view on page load.
    Split view is available when the following criteria is met:
  • The bill has a single attachment.
  • The attached file is a PDF, JPG, or PNG file.
  • Select the Transaction tab to view bill information, drill down into vendor details, and open attachments.
    See Bills page for more information about each field.
  • Select the Posting details tab to see how the bill posted to the General Ledger, provided the bill state is posted or paid.
    Posting details show for accrual books only and do not appear for all transactions. See View GL posting details—Accounts Payable for more details.
  • Select the History details tab to view the creation, modification, and approval Create a custom view to find bills that were placed on hold.
  • history of the bill.

Find bills on hold

Create a custom view to find bills that were placed on hold.

  • Go to Accounts Payable > All > Bills.
  • Select Manage view > Create new view.
  • Select Place this bill on hold to include the column in your view.
  • Select the following filter:
  • For Columns, select Place this bill on hold
  • For Operator, select equals
  • For Value, enter true
  • Give the view a name.
  • Select Deploy if you want the view to be available for other users.
  • Save the view.
  • Back on the Bills list, select your new view from the dropdown list next to Manage views.
    The list is filtered to show only those bills that are currently on hold. From here, you can release the hold.

Pay a bill from the Bills list

Typically, you pay bills on the Pay bills page. However, you can pay bills individually from the Bills list when the following conditions are met:

  • The bill was created at the same level.
  • The bill has been approved or does not require approval.
  • The bill is not on hold.
  • If you are using Release to pay, you previously released all line items in the bill.
  • The vendor is set up for your default payment method, if setup is required. For example, vendors must be enabled for services such as ACH, bank file, and check delivery.
  • If there is a default filter set for your Pay bills page, this bill is not excluded by that filter.
  • The amount of the bill is positive.

When these conditions are met, you can proceed with the following below;

  • Go to Accounts Payable > All >Bills.
    The Bills list appears. Bills that are eligible for payment from this page show a Pay link at the end of the row.
  • If you do not see the Pay link for the bill you want to pay
  • Verify that the bill state is Posted or Partially paid.
    If the state is Submitted or Partially approved, you need to wait until it’s approved (Posted) before you can pay it.
  • Make sure that you are at the same level where the bill was created.
    If you are at the entity level, go to the Bills list at the top level to pay a bill that was created there.
  • Verify that the bill is not on hold and that all line items have been released to pay.
    Line items need to be released only when you have Release to pay enabled.
  • Select the Pay link next to the bill you want to pay.
    A Pay bills popup appears, with the bill ready to be selected.
  • Select the payment options that you want to use, such as the Payment method, Bank currency, and Bank.
  • Select the bill in the list.
  • Optionally, apply all or a portion of the available credits.
    Select Apply credits to apply all credits available. To apply a portion, edit the Credits to apply amount, or drill down into Line details and apply credits to line items selectively.
  • To pay a portion of the bill, edit the Amount to pay.
  • Select Pay now or Add to outbox.
    A payment request is created. Depending on your configuration, the payment request might require approval before it can be paid.
    If you added the payment to the outbox, the payment request has a Payment status of Draft. When you’re ready to move it ahead in the workflow, go to the outbox from Pay bills, select the payment, and select Pay.

Next steps

Payments that require approval are ready to be approved by users with the appropriate permissions on the Approve Payments page.

For payments that have been approved or did not require approval, the next step is based on the payment method:

  • Record transfer (EFT and manual checks), cash, Vendor Payments powered by CSI, and credit card payments are immediately posted.
  • Checks, ACH payments, and Bank file payments, which are all managed within Sage Intacct, require action on your part before the payment is posted.

The following table shows the next steps to take for payments managed within Sage Intacct:

Learn more about the payment request workflow.

Solutions to try if you receive an error

Try the following solutions if you receive the error, “Because of bill or vendor validations currently in place, you cannot pay this bill from the Bills list. Try paying this bill from the Pay bills page.”

Save time entering bills

Make bill entry more efficient by doing the following:

  • Customize your setup to match the way that you work.
  • Use the autofill and duplicate options to create similar bills from the same vendor.

Use AP Automation to automatically create drafts

Skip data entry by having Sage Intacct create draft bills for you, from bill documents that you forward by email or upload directly. After the draft bills are created, all you need to do is review them, update coding details if needed, and then post or submit.

Contact your Sage Intacct account manager or Channel Executive to learn about enabling AP Automation.

Customize your configuration and preferences

Save time when entering a batch of vendor bills

Do you regularly enter a batch of bills from a single vendor all at once, using the Submit & new or Post & new buttons? If so, you can configure Intacct to copy the vendor name to the next bill, automatically.

In Configure Accounts Payable, under Screen Settings, select Autofill vendor information in the next transaction during multi-bill and multi-adjustment entry.

You need admin privileges to make this change. The setting must be set from the top level and affects all users in all entities. Learn more about screen settings in Configure Accounts Payable.

Automatically record the GL posting date

Did you enable the ability to override the GL posting date when entering a bill? If so, you can also configure the GL posting date to autofill with the transaction date.

In Configure Accounts Payable, under Screen Settings, select Autofill the GL posting date with the transaction date.

You need admin privileges to make this change. The setting must be set from the top level and affects all users in all entities. Learn more about screen settings in Configure Accounts Payable.

Customize the layout of line items to match the way you enter information

You can edit the line item layout for the bill entry form to:

  • Change the order of fields to reflect the order you use.
  • Add the dimensions and custom fields that you often enter.
  • Move fields that you do not use, so that they are only visible when you select Show details.

You need admin privileges to edit the layout. The changes you make affect all users within the entity where you make the change. Learn more about how to customize the layout.

Automatically show the bill attachment side-by-side with bill details

Set your user preferences so that bill attachments appear alongside bill details. Optionally, you can have attachments open by default when you view a bill.

This change only affects your experience. Learn how to personalize the split view settings.

Populate using details from the last bill

  • Go to Accounts Payable > All and select
  • Add (circle)
  • next to Bills.
  • Enter a Date.
  • Select a Vendor.
  • Select Populate from last bill to default bill information from the most recently created bill for this vendor.
  • Enter a unique Bill number.
  • If the original bill included attachments, update Attachment.
    Remove attachments that do not apply to the new bill and upload new attachments, as needed.
  • Edit the remaining bill details as needed.
  • Select Draft, Submit, or Post to save the transaction.

Duplicate an existing bill

  • Go to Accounts Payable > All > Bills.
  • Select View next to the bill you want to duplicate.
  • Select Duplicate.
    A copy of the bill opens in edit mode.
  • Enter a unique Bill number.
  • If the original bill included attachments, update Attachment.
    Remove attachments that do not apply to the new bill and upload new attachments, as needed.
  • Edit the remaining bill details as needed.
  • Select Draft, Submit, or Post to save the transaction.

Customize line-item entry fields

Make bill entry more efficient by configuring the line-entry fields to match how you work.

Set default values for line items

When entering a bill with many line items that share the same dimension values, you can save time by setting default values first.

For example, say you are entering a bill with 50 line items, where most lines are for the same Department and Location. Before entering the line items, set the default values to the Department and Location that you want and apply the defaults. Then, as you enter line items, you’ll see that Department and Location are prefilled on each line. You can override the defaults for any line that needs different coding.

Default values that you apply are used only for the bill you are currently entering. The values cleared for subsequent bills.

  • In the Entries section of the transaction page, select Show defaults.
    The Entries area expands to display all fields for which you can set line-item defaults. The type of fields that can appear here depend on your company set up.
  • For example, you can set default values if you have done the following:
  • enabled standard dimensions
  • created and deployed user-defined dimensions
  • created and deployed multi-currency processing fields
  • created and deployed revenue-recognition fields
  • Select the dropdown for any field that you frequently use the same value for and select that value.
  • Select Apply defaults above the first line item.
    The value that you selected appears in every line or in the line item detail of every line, depending on where the field is located. You can manually override this value for any line item.

Add, remove, and rearrange line-item fields

If you are an administrator with full privileges and are assigned the relevant permissions, Intacct enables you to customize field placement on a line-item table. You can move fields between the line item and its detail area and rearrange the order. For example, if your company uses some dimensions more frequently, you can display the frequently used dimensions, including user-defined dimensions, at the line level. Also, you can move the less frequently used dimensions to the line-item detail.

Any change made to the display of line items in a transaction-entry page affects all users of that page.

  • In the appropriate transaction page, select the More actions dropdown and select Edit entries layout.
  • Select the line item of interest.
    The Show Details tab appears.
  • Select Show details.
    The line item details appear in a dropdown.
  • Select and drag a field to move it to or from the line-item level.
  • Select Save layout.

Print a copy of a bill

You can print a copy from the Bill page itself or from the Bills list page, whichever is more convenient.

  • Go to Accounts Payable > All > Bills.
    If you’re viewing from the top level, you only see bills created at the top level. To view transactions created at the entity level, select Include private.
  • Find the bill that you want to print in the list.
  • To print from the list, select Print on the row.
    Sage Intacct generates a PDF of the bill, which you can view, print, or save to add as an email attachment, as needed.
  • To return to the list of records, close the output window.

Export a list of bills

Export a list of bills in CSV, Excel, Word, or PDF format, directly from the Bills list page.

  • Go to Accounts Payable > All > Bills.
    If you’re viewing from the top level, you only see bills created at the top level by default. To view transactions created at the entity level, select Include private.
  • Sort and filter the list to show the list as you want to export it.
    You can export up to 25,000 rows at a time.
    If you plan to export the list regularly, you might want to create a custom view that you can reuse.
  • Select Export and select an export option.
    CSV, Excel, and Word files are downloaded through your browser.
    PDF files open in a viewer automatically. You can download or print the file directly from the viewer.

Check out our Free Additional Articles