This article explains how to create a substantiated billings report in Sage Intacct, as demonstrated in the video tutorial available here.
Navigate to the Report:
Access the report section in Sage Intacct to view the invoice generated in the system.
Invoice Overview:
An example invoice dated 9/30 includes three bills from accounts payable.
Substantiating the Billing:
The custom report shows detailed breakdowns, including the invoice amount and the actual costs from accounts payable bills.
Attach Report to Invoice:
Generate the invoice first, then edit to attach the report, saving it as a PDF.
Email Functionality:
Use Sage Intacct's email function to send the invoice to the customer, including the attachments for accounts payable bills.
Creating the Custom Report:
Navigate to the custom reports area.
Use 'order entry transaction detail' and select the appropriate columns.
Rename columns as needed and adjust their order.
Include totals for extended price and cost amount.
Group by cost code and include prompts for project ID and invoice date.
Saving and Attaching the Report:
After building the report, save it, add it to the menu, and run it post-billing.
Save the report as a PDF and attach it to the invoice.
Email Template Setup:
Ensure the email template includes document attachments and source document inclusion.
Sending the Email:
The email will include the invoice, accounts payable attachments, and the substantiated billing report.
The tutorial mentions other related live streams on email templates, billing simplification, and custom report writing.
Creating a substantiated billings report in Sage Intacct involves generating a detailed report of invoice components, attaching it to the invoice, and emailing it to the customer with all necessary attachments for full transparency.
Source Video:Building a Substantiated Billings Report in Sage Intacct
Note: This article provides a summary of the process as described in the video. For a step-by-step visual guide, refer to the linked tutorial.