AP Bills

This integration provides bidirectional AP bill synchronization between Sage Intacct and Zudello, supporting both data retrieval for transaction history and bill creation for accounts payable processing.

Inbound (Sage Intacct → Zudello)

📥 Direction: Sage Intacct → Zudello

AP bill data flows from Sage Intacct to Zudello to provide a complete history of accounts payable transactions.

Header Field Mappings

Zudello Field	Sage Intacct Field	Notes
Supplier	VENDORID	Links to the supplier record.
Company Name	VENDORNAME	The name of the supplier.
Document Number	RECORDID	The AP bill number from Sage Intacct.
Reference	DOCNUMBER	The vendor's invoice number.
Description	DESCRIPTION	The description of the bill.
Date Issued	WHENCREATED	The date the bill was created.
Date Posted	WHENPOSTED	The date the bill was posted.
Date Due	WHENDUE	The payment due date.
Subtotal	SUBTOTAL	The net amount before tax.
Tax	TAXTOTAL	The total tax amount.
Total	TOTAL	The total amount including tax.
Currency	CURRENCY	The currency of the bill.
Status	STATE	The status of the bill (e.g., Open, Paid).
Payment Status	PAYMENTSTATUS	The payment processing status.

Line Item Field Mappings

Zudello Field	Sage Intacct Field	Notes
Description	ENTRYDESCRIPTION	The description of the line item.
Line Number	LINE_NUM	The line sequence number.
Quantity	QUANTITY	The quantity on the bill line.
Unit Price	PRICE	The unit price, excluding tax.
Total Exclusive	TRXAMOUNT	The line total, excluding tax.
Tax	TAXAMOUNT	The tax amount for the line.
Total	TOTALAMOUNT	The line total, including tax.
Item	ITEMID	Links to the item record.
Account	ACCOUNTNO	Links to the GL account.
Location	LOCATIONID	Links to the location.
Department	DEPARTMENTID	Links to the department.
Project	PROJECTID	Links to the project.
Cost Centre	CLASSID	Links to the cost centre.
Tax Rate	TAXTYPE	Links to the tax rate.

Key Behaviours (Inbound)

• Incremental Sync: To save time, the integration only syncs bills that are new or have been updated since the last check.
• Payment Status Tracking: The integration syncs the payment status of bills, allowing for accurate tracking of open, paid, and partially paid bills.
• Full Detail Sync: Bills are synced with all their line items and dimensional data.

Outbound (Zudello → Sage Intacct)

📤 Direction: Zudello → Sage Intacct

AP bills are created in Sage Intacct from Zudello to process accounts payable invoices.

Header Field Mappings

Intacct Field	Zudello Field	Notes
VENDORID	supplier.code	The supplier's unique code.
WHENCREATED	date_issued	The date the bill was issued.
WHENPOSTED	date_posted	The date the bill is posted.
WHENDUE	date_due	The due date for the bill.
RECORDID	document_number	The bill document number.
DOCNUMBER	reference	The reference number for the bill.
DESCRIPTION	-	A link back to the document in Zudello.
CURRENCY	currency.code	The currency of the bill.
TAXSOLUTIONID	-	A fixed tax solution is used (e.g., "Australia - GST").

Line Item Mappings

Intacct Field	Zudello Field	Notes
ACCOUNTNO	account.code	The GL account for the line item.
TRXAMOUNT	total_exclusive	The line amount, excluding tax.
TAXAMOUNT	tax_amount	The tax amount for the line.
ENTRYDESCRIPTION	description	The description for the line item.
LOCATIONID	location.code	The location for the line item.
DEPARTMENTID	department.code	The department for the line item.
PROJECTID	project.code	The project for the line item.
CLASSID	cost_centre.code	The cost centre for the line item.
ITEMID	item.code	The item code (excluded for expense-type bills).
TAXTYPE	tax_rate.code	The tax rate for the line item.

Key Behaviours (Outbound)

• Dimensional Tracking: The integration supports full tracking across dimensions like locations, departments, projects, and cost centres.
• File Attachments: If the bill has a file attached in Zudello, it will be attached to the AP bill in Sage Intacct.
• Fixed Tax Solution: A standard tax solution (e.g., "Australia - GST") is used for consistency.

Related Documentation

• Purchase Orders
• Purchase Invoices
• Vendor Records
• Items
• Accounts
• AP Terms
• Tax Rates
• Cost Centres
• Projects
• AP Adjustments
• AP Credits