Step 5 — Generate Report: See your full cash position — AR coming in, AP going out, and net.
💡 Tip: Use Cash Basis in QuickBooks. Steps 2 and 3 are optional — skip either one and the report still runs with whatever you have.
1
Upload QuickBooks Export
CSV or Excel file from the Open Invoices report
📂
Drag your file here, or click to browse
Accepts .csv or .xlsx files exported from QuickBooks
✅
File uploaded
⚠️
Make sure you exported the Open Invoices report from QuickBooks as CSV. If you're still having trouble, contact Robert.
2
Upload Shipping Schedule from Box (optional)
Upload the KH Shipping & Payment Schedule Excel file — ship dates Kenny entered will be matched automatically
📅
Drag the KH Shipping & Payment Schedule here, or click to browse
This is the Excel file from Box with Kenny's ship dates in column H
✅
Ship dates matched
3
Upload QuickBooks Unpaid Bills (AP — what KH owes vendors)(optional)
In QuickBooks → Reports → search "Unpaid Bills" → Export to Excel
📤
Drag your Unpaid Bills export here, or click to browse
Accepts .csv or .xlsx from QuickBooks Unpaid Bills report
✅
AP file uploaded
4
Review Invoices & Confirm Shipping Dates
Auto-matched dates are highlighted green. Add or edit any dates, then generate the report.
Client
Invoice #
Invoice Date
Amount
Balance Due
Expected Ship Date ★
Net 30?
Notes
Shipping date tip:
The balance payment is due before shipping, so enter the date you expect each order to ship. Leave blank if no ship date is set yet.