AP Bills Entry

The AP Bills Entry Writeback template creates vendor bills in Sage Intacct directly from a workbook. Use it to enter vendor invoices and other accounts payable expenses without entering each bill manually in Sage Intacct. The template uses the NECWRITEBACK formula, generated with the Writeback Wizard, to send the completed bill to Sage Intacct.

Typical workflow

1. Complete the bill header.
2. Enter the transaction lines in the bill grid.
3. Review the Validation column and correct any line-level errors.
4. Confirm the Lines Entered, Total Bill Amount, and Entry Status in the entry summary.
5. Select Push to Intacct to create the bill.
6. After a successful writeback, use the populated reference number to open the bill in Sage Intacct.
7. Select Reset before preparing another bill.

Bill header

Contains information shared by all transaction lines in the bill.

Bill field	What it shows
Bill number	Vendor invoice or bill number used to identify the document.
Reference number	Reference number returned by Sage Intacct after a successful writeback. The populated value links to the created bill.
Date *	Date of the vendor bill.
GL posting date	Date the bill is posted to the general ledger.
Description	Brief description of the bill.
Base currency *	Base currency used for the bill.
Vendor *	Vendor associated with the bill.
Pay to	Vendor contact or address to which payment should be sent.
Return to	Vendor contact or address used for returns, when applicable.
Term	Payment terms used to determine the due date.
Due date *	Date by which payment is due.
Recommended to pay on	Suggested payment date for the bill.
Payment priority	Priority used when selecting the bill for payment.
Place bill on hold	Prevents the bill from being selected for payment until the hold is removed.

important

Fields marked with an asterisk (*) are required. Depending on the Sage Intacct configuration, additional dimensions may also be required, such as department, class, or project.

Writeback actions

Writeback action	What it does
Push to Intacct	Validates the completed template and creates the bill in Sage Intacct. A confirmation message indicates whether the writeback succeeded.
Reset	Clears the current bill so the template can be used for another entry. Use this only after the current bill has been successfully written back or is no longer needed.

Bill grid

Contains the individual transaction lines that make up the bill. The Total Bill Amount at the bottom of the grid is calculated from the entered transaction lines.

Bill grid column	What it shows
Account *	General ledger expense or asset account assigned to the line.
Vendor	Vendor associated with the transaction line, when applicable.
Amount *	Amount of the transaction line.
Allocation	Allocation definition used to distribute the line amount, when applicable.
Location *	Location associated with the transaction line.
Department	Department associated with the transaction line, when applicable.
Class	Class associated with the transaction line, when applicable.
Project	Project associated with the transaction line, when applicable.
Task	Project task associated with the transaction line, when applicable.
Memo	Description or memo for the individual transaction line.
Validation	Displays missing field errors, invalid combinations, or confirmation that the line is ready.

Review the entry before writeback

• Confirm that all required (*) header fields are complete.
• Resolve any errors shown in the Validation column.
• Check the Lines Entered and Total Bill Amount in the entry summary.
• Confirm that the Entry Status indicates the bill is ready for writeback.

The bill can be written back only when all required fields are complete and no line-level errors remain.