For an in depth video walkthrough please visit peAk and watch our Lunch & Learn here:
Overview
The Billing History Workbook (billingHistory_v04.03.xlsm) is an Excel-based tool that connects directly to your INNERGY project data via API to generate two standard billing documents:
● Form A — Billing Worksheet (SOV continuation sheet / AIA G703-style)
● Form B — Application and Certificate for Payment (cover sheet / AIA G702-style)
Prerequisites
● Microsoft Excel (macros must be enabled)
● Your INNERGY API Key
● The billingHistory_v04.03.xlsm workbook
● An active INNERGY project with a Schedule of Values
Once all prerequisites are confirmed, follow these 11 steps to complete your billing draw from INNERGY to your final AIA payment application.
Step 1 — Enable Macros
When you first open billingHistory_v04.03.xlsm, Excel will prompt you to enable macros.
1. Click Enable Content in the yellow security bar at the top of Excel.
2. Macros must be enabled for the workbook's import/export buttons to function.
⚠️ If you do not see the Enable Content prompt, go to File → Info → Enable Content.
Step 2 — Enter Your API Key
The workbook connects to INNERGY using your personal API key.
3. Navigate to the Project Summary tab.
4. Locate the API Key: field in the upper-left area of the sheet.
5. Enter your INNERGY API key in the cell to the right of the label.
💡 Finding your API key: In INNERGY, go to your user profile/settings and look for the API Key section. Copy and paste it directly into this cell.
Step 3 — Import Project Data from INNERGY
Once your API key is entered, pull in your project's data.
6. On the Project Summary tab, locate the Import button (or the designated data-refresh control).
7. Click it to connect to app.innergy.com and pull your project's information.
8. The following fields will populate automatically from INNERGY:
Field | Source |
Project Number | INNERGY Project # |
Project Name | INNERGY Project Name |
Customer | INNERGY Customer Name |
Project Manager | Assigned PM in INNERGY |
PM Email | PM's email address |
Project Status | Current status in INNERGY |
Project Address | Project location fields |
9. Verify the populated data matches the correct project before proceeding.
Step 4 — Configure Tax & Retainage Option
10. On the Project Summary tab, locate the Tax & Retainage Option field.
11. Select the appropriate setting from the dropdown (e.g., Tax Before Retainage Held).
12. This setting controls how taxes are calculated across Forms A and B.
Step 5 — Review the Draw Data
The draw Data tab is the source of your SOV line items, pulled from INNERGY.
13. Click the draw Data tab.
14. Confirm the following columns are populated correctly:
Column | Description |
Item # | SOV line item number |
Description of Item | Line item description |
Scheduled Value | Original scheduled value (pre-tax) |
Sales Tax | Tax applied to the line item |
Total Scheduled Value | Scheduled Value + Sales Tax |
From Previous Application | Amount billed in prior draw(s) |
This Period | Amount to bill in the current draw |
15. If line items are missing or incorrect, verify the SOV is set up properly in INNERGY before re-importing.
Step 6 — Enter Current Period Billing Amounts
★ KEY DATA-ENTRY STEP — This is the only step where you enter dollar amounts for the current draw. All prior billed amounts carry forward automatically.
16. On the draw Data tab (or directly on Form A), locate the This Period column.
17. Enter the dollar amount you are billing for each SOV line item in the current draw.
18. The workbook will automatically calculate:
○ Total Completed & Stored (Previous + This Period + Stored Materials)
○ % Complete per line item
○ Balance to Finish
○ Retainage (if applicable)
💡 Enter only the current period amounts. Prior billed amounts are carried forward automatically.
Step 7 — Enter Application Details
19. Return to the Project Summary tab.
20. Fill in the following fields:
Field | Description |
Invoice Number | Your invoice number for this draw |
Application Number | Sequential draw number (e.g., 1, 2, 3…) |
Application Date | Date of this billing application |
Period From | Start date of the billing period |
Period To | End date of the billing period |
Step 8 — Review Form A (Billing Worksheet)
21. Click the Form A tab.
22. Confirm all SOV sections are correct:
Form A — SOV sections
● Original Contract line items and totals
● Approved Changes section
● Current Contract total
● Pending Changes section
Form A — Header and totals
23. Verify the header information: Project Name, Client Name, Application Number, Period To, Contract #.
24. Confirm column totals match expected values before printing.
Step 9 — Review Form B (Application and Certificate for Payment)
25. Click the Form B tab.
26. This form summarizes the full billing application. Confirm the following fields at the top of the form:
Form B — Header fields
● To General Contractor / Attn fields (if applicable)
● Project name
● From Contractor (your company name from INNERGY)
Form B — Financial summary lines
Verify each line in the financial summary section:
Line # | Field | Description |
1 | Original Contract Sum | Total contract amount at signing |
2 | Net Change by Change Orders | Sum of all approved change orders |
3 | Contract Sum to Date | Lines 1 + 2 |
4 | Total Completed & Stored to Date | Cumulative work completed including materials stored |
5 | Retainage | Held-back percentage per contract terms |
6 | Total Earned Less Retainage | Line 4 minus Line 5 |
7 | Less Previous Certificates for Payment | Total already paid in prior draws |
8 | Current Payment Due | Line 6 minus Line 7 — amount due this draw |
27. Verify the Invoice Number and Subcontract # fields are populated.
Step 10 — Print / Export Forms
28. With Form A or Form B active, use the workbook's Export button (or standard Excel print) to generate your output.
29. Recommended: Export as PDF for submission to the General Contractor or Owner.
30. Print both Form A and Form B as a complete billing package.
Step 11 — Archive the Completed Forms
After the draw is approved and submitted:
31. Use the workbook's Archive function (button on the Project Summary or dev tab) to save a snapshot of this draw period.
32. Archiving preserves the current period data so it rolls forward correctly as "From Previous Application" in the next draw.
33. Confirm the archive was successful before entering data for the next billing period.
⚠️ Do not skip archiving. Failing to archive before starting the next draw will cause incorrect carry-forward amounts in Forms A and B.
Troubleshooting
Issue | Solution |
Data does not import from INNERGY | Verify your API key is entered correctly with no extra spaces |
Line items are missing from draw Data | Check that the SOV is fully set up in INNERGY and re-import |
Retainage calculations look wrong | Confirm the Tax & Retainage Option setting on Project Summary |
Macros are disabled | Click Enable Content in the Excel security bar and reopen |
Form totals don't match | Ensure "This Period" values are entered only in the draw Data tab, not overridden manually on Form A |
Recent Updates and Improvements:
v 04.03:
Corrected a formula error on Form B. The formula in cell O36 should be:
=originalContract[[#Totals],[This Period]] + approvedChanges[[#Totals],[This Period]]
You can use this formula to correct any of your existing workbooks as well.