Sample monthly report · Demo data

Sample Monthly Report: What Headquarters Receives from Its U.S. Subsidiary

Below is the September 2026 management report for a fictional company, in the format we deliver to clients every month: conclusions and variance reasons first, then the statements, balances, compliance status and the decisions headquarters needs to make, with the account mapping attached for consolidation. The company, people and every figure are demo data.

Demo data: Sample Energy (US) Inc. is a fictional company and is not based on any real business; the figures only show the format and the analysis. Real reports follow each client's chart of accounts, variance thresholds and headquarters' format, in Chinese and English. Parts tagged “Fractional CFO module” come with the fractional CFO service; everything else is in the standard monthly report.

DEMO DATA

Sample Energy (US) Inc. · Management Report, September 2026

Period2026-09-01 to 09-30
Currency and unitU.S. dollars, whole dollars
Accounting basisU.S. GAAP, accrual
Version and closeFinal v1.0 · September closed
Sent2026-10-14
ToHQ finance · U.S. general manager

1. Summary

  • Revenue of 1,284,600, 75,000 (6.2%) above budget. Mainly a Texas installer's order of about 92,000, originally planned for October, delivered in September.
  • Gross margin of 26.2%, 1.8 points below budget and 1.3 points below August. Ocean freight and duty rose on shipments arriving from late August, lifting landed cost by about 3%; the Texas order was also priced below average. Sales leadership to confirm whether October pricing changes.
  • Net income of 77,100, 5,900 below budget and 6,900 (8.2%) below August. Beyond margin: a one-off legal fee of 3,400 (distributor contract review) and higher freight-out with volume.
  • Month-end cash of 842,100, about 3.7 months of operating expenses (excluding inventory purchases). 48,700 of receivables is over 60 days (two distributors); reminders sent and new credit to both paused.
  • Year to date: revenue 10,723,400, 76.1% of the full-year budget of 14,100,000; net income 702,300.

2. Income statement: actual vs budget and prior month

Variance: favorable to profit is positive, unfavorable in parentheses. Income tax accrued at the expected full-year effective rate of 26% (21% federal plus state).
Line itemActualBudgetVarianceVar. %August
Revenue1,284,6001,209,60075,0006.2%1,231,800
Cost of goods sold948,300870,900(77,400)(8.9%)893,100
Gross profit336,300338,700(2,400)(0.7%)338,700
Gross margin26.2%28.0%(1.8 pts)—27.5%
Payroll and benefits138,600140,0001,4001.0%138,600
Rent and warehouse31,20031,20000.0%31,200
Freight-out29,80026,600(3,200)(12.0%)27,100
Professional fees12,4009,000(3,400)(37.8%)8,900
Other operating expenses15,30015,000(300)(2.0%)14,600
Total operating expenses227,300221,800(5,500)(2.5%)220,400
Operating income109,000116,900(7,900)(6.8%)118,300
Interest expense (parent loan)4,8004,80000.0%4,800
Income before tax104,200112,100(7,900)(7.0%)113,500
Income tax expense (accrued)27,10029,1002,0006.9%29,500
Net income77,10083,000(5,900)(7.1%)84,000

Swipe to see all columns

Material variances (threshold: ±5% and ±2,000)

  • Cost of goods sold (77,400): about 54,000 follows the higher revenue at budget margin; the remaining 23,400 is higher landed cost and the lower-priced Texas order.
  • Freight-out (3,200): volume above budget; the Texas order was delivered to site.
  • Professional fees (3,400): legal review of the distributor contract — one-off, back to normal from October.

3. Cash, key balances and related-party balances

Item9/308/31ChangeComment
Cash842,100905,600(63,500)Paid the parent 950,000 for goods in September
Accounts receivable966,400948,20018,20048,700 over 60 days (two distributors), being chased
Inventory1,522,8001,486,30036,500Includes 214,000 in transit, arriving early October
Due to parent, trade488,300561,900(73,600)Agreed to headquarters’ books at 9/30
Loan from parent1,200,0001,200,00004.8% a year, interest paid quarterly
Interest payable to parent14,4009,6004,800Q3 interest, paid 10/5

Swipe to see all columns

Cash movement: from profit to cash

ItemAmountComment
Cash at 8/31905,600
Net income77,100
Depreciation and other non-cash items3,900
Increase in receivables(18,200)Follows revenue growth
Increase in inventory(36,500)Includes 214,000 in transit
Decrease in due to parent(73,600)Paid 950,000 against purchases of 876,400
Increase in interest payable4,800Q3 interest paid 10/5
Income tax: 27,100 accrued, 66,000 third federal installment paid 9/15(38,900)California has no September installment
Accrued expenses and other17,900Mainly accrued wages and bonus
Cash at 9/30842,100

Short-term cash forecast (13 weeks, weekly) FRACTIONAL CFO MODULE

  • Base case: after the Q4 inventory payment to the parent of about 620,000 in the second week of November (11/9), cash bottoms at about 210,000 and recovers above 600,000 once December collections arrive.
  • Downside case (two large distributors each pay two weeks late): cash falls below the 100,000 safety line in the second and third weeks of November, bottoming at about −40,000 — which is the $300,000 in decision 1.
  • Committed payments: payroll and sales tax of about 58,000 on 10/20; interest withholding of 1,440 on 11/15; federal estimated tax of about 66,000 on 12/15.

Working-capital indicators

Receivable days 22.6 (August 23.1) · inventory days 48.2 (August 49.9) · receivables over 60 days 48,700

Related-party activity

  • Due to parent, trade: 561,900 at 8/31 + purchases 876,400 − payments 950,000 = 488,300 at 9/30, agreed to headquarters' books.
  • Interest on the parent loan: 4,800 accrued this month; Q3 interest of 14,400 paid 10/5 with 10% treaty withholding (1,440), to be deposited by 11/15 and reported on the 2026 Forms 1042 / 1042-S. Interest owed to a foreign related party is deductible only when paid; paid quarterly, this year's interest is fully deductible.
  • Form 5472 tracker: reportable related-party transactions January–September — purchases from the parent 7,046,000, loan interest 43,200, loan balance 1,200,000 — accumulated monthly and carried straight into the year-end return.
  • Transfer pricing: purchases priced under the 2026 transfer pricing policy; year-to-date operating margin of 9.3% is within the policy range. If landed cost keeps rising in Q4, we suggest discussing a year-end adjustment with headquarters in November — it needs written support before 12/31, and it also changes the customs value of imports, so the customs broker should be involved.

4. Compliance status

ItemPeriodDueStatus
Federal payroll tax deposits (semiweekly)SeptemberPer payrollDeposited on time
Form 941 · California DE 9 / DE 9CQ3 202610/31Prepared, filing 10/20
Texas sales tax (monthly)September10/20Filed 10/9
California sales tax (quarterly)Q3 202610/31Reconciled, filing 10/26
Form 1120 + Form 5472202510/15 (extended)Filed 10/8
California Form 100202510/15 (extended)Filed 10/8
Withholding deposit on parent interestOctober11/151,440, to be deposited
Federal estimated tax, 4th installment202612/15About 66,000 — see decision 2
Forms 1042 / 1042-S20262027-03-15Interest tracked quarterly
Parent’s Form W-8BEN-E—Valid to 2028-12-31Valid; update within 30 days of any change

Swipe to see all columns

5. Three decisions for headquarters

  1. 1. Fund the next $300,000 of working capital as equity or as a parent loan? (Please decide by 10/31.) A loan: interest is deductible in the U.S. (interest to a foreign related party when paid), 10% treaty withholding applies when interest is paid, the rate must be arm's length and the loan documented in writing. Equity: no interest deduction, and future dividends also carry 10% treaty withholding, but the balance sheet is stronger for bank credit. Our recommendation: this is seasonal inventory funding to be repaid within 12 months, so a loan fits better; for long-term expansion capital, use equity.Decision owner: HQ head of finance · by 10/31 · if not decided: cash drops below the safety line in mid-November in the downside case (see the forecast in section 3)
  2. 2. Q4 estimated tax (due 12/15). On nine months of actuals plus the Q4 forecast, 2026 taxable income is about 1,260,000 and the fourth federal installment about 66,000 (California separate). If a large equipment purchase or a transfer pricing adjustment is planned for Q4, tell us by 11/20 — the amount will change.Decision owner: U.S. general manager + HQ finance · by 11/20 · if not decided: we pay on the current forecast; underpaying triggers the estimated-tax underpayment penalty
  3. 3. Year-end consolidation package timeline (please confirm the auditor's dates). Working back from delivery on 1/20: inventory count 12/31 (does headquarters or the auditor need to observe?), U.S. close 1/10, related-party balances confirmed by both sides 1/15, consolidation schedules and the bilingual annual report delivered 1/20. If the auditor needs it earlier, please tell us by the end of November.Decision owner: HQ finance (with the auditor) · by 11/30 · if not decided: we run to the 1/20 plan; an earlier auditor date would compress the close
Prepared by: B&G accounting teamReviewed by: Jenny Gao, CPA, EASent: 2026-10-14

Appendix: account mapping excerpt (U.S. books → China Accounting Standards)

QuickBooks accountHeadquarters account (China Accounting Standards)This monthNote
4000 Sales – Products6001 Main business revenue1,284,600
5000 Cost of Goods Sold6401 Main business cost948,300Includes inbound freight and duty
6000 Salaries & Wages · 6050 Payroll Taxes & Benefits6601 Selling expenses – staff costs / 6602 Admin expenses – staff costs138,600Split by department: selling 82,300 / admin 56,300
6200 Rent & Warehouse6601 Selling expenses – warehousing / 6602 Admin expenses – rent31,200Warehouse 24,000 / office 7,200; lease-standard adjustments sit in the consolidation schedule
6300 Freight-out6601 Selling expenses – freight29,800
6500 Legal & Professional Fees6602 Admin expenses – professional fees12,400Includes one-off legal fee of 3,400
7100 Interest Expense – Related Party6603 Finance costs – interest4,800Related party: parent
8000 Income Tax Expense6801 Income tax expense27,100
1300 Inventory1405 Goods in stock / 1402 Goods in transit1,522,800214,000 in transit shown as goods in transit for headquarters
2010 Due to Parent – Trade2202 Accounts payable – parent488,300Related party, agreed each month-end
2600 Loan from Parent2241 Other payables – parent loan1,200,000Related party

Swipe to see all columns

The U.S. books are kept on a U.S. basis; differences from headquarters' basis (for example leases or inventory write-downs) are adjusted in the consolidation schedule, not in the U.S. ledger. The full mapping is agreed with headquarters' finance team in the first month and reused every month after.

Once more: the company, people and figures above are fictional and are not tax or accounting advice for any specific situation. To see what your own monthly report could look like, send us the format headquarters asks for today.

Related: Monthly close playbook for U.S. subsidiaries · Bridging PRC GAAP books to U.S. GAAP and tax basis · What a Chinese parent needs for year-end consolidation