Advanced billing in Sage Intacct can streamline your project management and accounting workflows. This guide covers summarized time and material billing for AIA (American Institute of Architects) forms, segregating fees, and leveraging progress billing for detailed over-under reports based on costs.

Summarized Time and Material for AIA

Setting Up Contract Lines

• Contract Header: Set up as usual.

• Time and Material Basis: Set up with the summarize checkbox on.

• This summarizes costs linked to cost codes associated with a specific AIA line (e.g., 01 General Conditions).

• Include a rate table if rates need to flow through at the line level.

• Assign a Schedule of Values amount for specific lines.

Billing and Adjustments

• After generating the invoice, costs are summarized under their respective AIA lines.

• Adjustments can be made either in total or at the line level for clarity in historical analysis.

Segregating Fee at the Bottom of an AIA

Contract Line Setup

• Time and Material Lines: Set up without the rate table to exclude fee from these lines.

• Progress Billing Line for Fee: Set this at the bottom with the billing type as 'progress bill'.

• Manual Fee Input: The fee amount at the bottom of the AIA needs to be entered manually.

Invoice Creation

• Costs flow through the summarized T&M lines.

• Enter the fee manually at the progress billing line.

Progress Billing with Cost Code Mapping

This setup allows for a report showing the schedule of values line number, billed amount, related costs, and over-under billing amount.

Required Setup

• Contract and Line Setup: Normal AIA setup with progress bill types.

• Parent Cost Code Mapping: Assign a WBS (Work Breakdown Structure) code to parent cost codes that correspond to AIA line numbers.

Generating Reports

• The report displays costs grouped by WBS codes corresponding to AIA lines, comparing billed amounts to actual costs.

• It provides a detailed view of billing versus costs for each schedule of values line.

Conclusion

Mastering these advanced billing techniques in Sage Intacct can significantly enhance your billing accuracy and reporting capabilities. Whether it's for detailed project tracking or simplified invoicing, these methods offer a robust solution for managing complex billing scenarios in construction accounting.

For a visual demonstration and further insights on implementing these advanced billing techniques in Sage Intacct, check out the informative video here: Advanced Billing Techniques in Sage Intacct. This resource is invaluable for those looking to optimize their billing processes within Sage Intacct.