SmartHelping / Accounting / Excel
Sales and Purchases on Account
Build a balanced 3-statement forecast when sales, cash collections, purchases, payments, and accounting recognition happen in different periods. This unlocked Excel model connects the timing logic across the income statement, balance sheet, and cash flow statement.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
See how transaction timing flows through all three statements.
Watch the walkthrough, then open the screenshots for a closer look at the assumptions, schedules, financial statements, and visual outputs.
What the model includes
A complete timing engine for accrual accounting.
Model when a transaction occurs, when cash moves, and when revenue or expense is recognized without losing the connections among the three financial statements.
Keep the balance sheet, income statement, and cash flow linked
Use one connected set of formulas so every modeled transaction reaches the appropriate statement and the balance sheet remains balanced.
Forecast monthly and review annually
Build detailed monthly schedules across ten years while retaining annual views for higher-level planning and presentation.
Inspect the full calculation flow in one place
Follow the assumptions, timing patterns, formulas, and outputs without navigating a maze of hidden or disconnected worksheets.
Separate a sale from the cash received
Apply flexible customer cash-collection patterns to future sales and see the corresponding movement in cash, receivables, and deferred revenue.
Separate a purchase from the cash paid
Schedule supplier payments independently from the purchase date and connect the timing to inventory, prepaid expenses, and accounts payable.
Control when revenue and costs reach earnings
Use recognition patterns for sales and costs so the income statement reflects delivery or consumption rather than cash timing alone.
Turn accounting schedules into readable outputs
Use three included visualizations to interpret the model and communicate important financial trends more quickly.
Adapt the Excel logic to your own use case
Review and edit the formulas, assumptions, labels, and structure. The workbook can also be uploaded to Google Sheets.
The linked statement framework
Follow every timing difference to the account it affects.
The model demonstrates how cash timing and accounting recognition move through the core accounts required for a balanced 3-statement forecast.
Balance sheet
Track cash, accounts receivable, inventory, prepaid expenses, accounts payable, unearned revenue, and retained earnings.
Income statement
Calculate recognized revenue, cost of goods sold, other recognized expenses, and net income based on the selected recognition schedules.
Cash flow statement
Reconcile net income to cash by reversing noncash recognition and incorporating collections, expense payments, inventory purchases, and other working-capital movements.
Integrated checks
Use consistent line-item references and formulas to keep the three statements connected as transaction timing changes across the monthly forecast.
How to use it
Move from transaction assumptions to balanced statements.
Enter future sales and costs
Build the monthly transaction forecast that will drive revenue, inventory, cost of goods sold, and operating expenses.
Set the cash timing patterns
Define when customers pay and when suppliers or other vendors are paid relative to the original transaction month.
Set the recognition patterns
Choose when sales and costs are recognized so deferred revenue, receivables, inventory, prepaids, and payables move correctly.
Review the statements and charts
Check the monthly and annual financial statements, confirm the balance sheet remains balanced, and use the visuals to interpret the results.
Two practical accounting examples
See why transaction date, cash date, and recognition date matter.
The workbook is designed to handle common timing differences like upfront customer payments and inventory purchased on supplier credit.
$1,200 subscription paid upfront
A customer pays $1,200 on January 1 for one year of service. Cash and deferred revenue increase immediately, then $100 of revenue is recognized each month as the service is delivered.
$5,000 of inventory purchased on credit
Inventory and accounts payable increase when the goods arrive, cash falls when the supplier is paid, and $5,000 of cost of goods sold is recognized when the inventory is sold for $7,000.
Who gets value from it
Built for anyone who needs accrual timing to balance correctly.
Financial modelers
Use a working example of the formulas and schedules needed to keep a monthly 3-statement model balanced.
Accountants and finance teams
Translate cash collection, payment, deferral, and recognition assumptions into connected forecast statements.
Founders and business owners
Understand why profit and cash can move differently when customers or suppliers transact on account.
Students and analysts
Study a practical Excel implementation of receivables, payables, inventory, deferred revenue, and retained earnings.
Also available in these bundles
Need a broader spreadsheet library?
The Sales and Purchases on Account model is also included in the Accounting Templates bundle and the Super Smart Bundle.
Accounting Templates
Build out the practical accounting, cash management, cost analysis, and financial reporting tools used across day-to-day operations.
View Accounting TemplatesSuper Smart Bundle
Get the complete SmartHelping template collection for forecasting, valuation, accounting, financing, real estate, and more.
View Super Smart BundleMore accounting spreadsheet tools
Extend the accounting and operating analysis.
Use these complementary SmartHelping templates for reporting, working-capital planning, costing, tracking, financing, and project-level decisions.
Discount Bond Model
Calculate bond pricing, discount accretion, interest expense, and cash repayment over time.
Explore the bond modelActivity-Based Costing Model
Assign overhead and indirect costs to the activities and outputs that consume them.
Explore the ABC model13-Week Cash Flow Planner
Build a weekly budget, track actual cash movement, and identify near-term liquidity pressure.
Explore the cash-flow plannerFinancial Statement Generator
Turn operating entries into linked income statement, balance sheet, and cash-flow outputs.
Explore the statement generatorCOGS Inventory Template - FIFO Based
Calculate inventory value and cost of goods sold using a first-in, first-out approach.
Explore the FIFO templateCash Conversion Cycle
Analyze how quickly inventory, receivables, and payables convert operating activity into cash.
Explore the cash-cycle modelAccounts Receivable and Payable Tracker
Monitor customer balances, vendor obligations, due dates, and collection or payment status.
Explore the AR/AP trackerVolume Discount Pricing
Evaluate tiered pricing and the margin impact of discounts at different order volumes.
Explore the pricing modelGeneral Loan Amortization
Build a flexible principal, interest, and payment schedule for debt planning.
Explore the loan scheduleCost Segregation Study
Classify real-estate components by recovery period and compare depreciation timing.
Explore the cost-segregation modelBudget vs Actual Planner
Compare monthly plans with realized results and investigate financial variances.
Explore the budget tracker90-Day Cash Flow Planner
Track shorter-term cash movement in a rolling daily planning format.
Explore the 90-day plannerWACC Calculator
Estimate the blended cost of debt and equity for valuation and investment analysis.
Explore the WACC calculator3-Statement Financial Model - For Startups
Connect revenue, expenses, financing, and working capital across all three statements.
Explore the startup modelEquipment ROI Calculator
Compare an equipment investment with its expected savings, cash flow, and return.
Explore the equipment analysisTracking Billable Hours
Record time by person, client, or project and translate hours into billable value.
Explore the time trackerTo-Do List Tracker
Organize tasks, priorities, ownership, timing, and completion status in Excel.
Explore the task trackerJob Bidding
Build detailed job estimates and evaluate pricing, costs, and expected profit.
Explore the bid templateInventory Template for a 3-Statement Model
Link inventory purchasing, usage, balances, and cash timing into financial statements.
Explore the inventory modelPayroll Calculator and Tracker - Budget vs Actual
Plan payroll by employee and compare expected compensation with actual results.
Explore the payroll trackerProfit / Loss and Cash Flow Tracking
Track operating performance and liquidity in real time as transactions occur.
Explore the financial trackerBreak-Even Analysis
Calculate the sales volume required to cover fixed and variable operating costs.
Explore the break-even modelDepreciation Expense Tool
Track asset depreciation schedules and expense across a large fixed-asset base.
Explore the depreciation toolDepreciation Recapture Calculator
Estimate recapture exposure and after-tax proceeds when a depreciated asset is sold.
Explore the recapture calculatorExpense Tracker
Record and categorize spending in an Excel or Google Sheets-based workflow.
Explore the expense trackerFinancial Statement KPIs
Calculate a broad set of liquidity, profitability, leverage, and efficiency ratios.
Explore the KPI calculatorGoogle Sheet Inventory Tracker
Monitor inventory movements and balances in a collaborative cloud spreadsheet.
Explore the inventory trackerInventory Reordering Planner
Estimate when stock should be reordered and how much should be purchased.
Explore the reorder plannerInventory Restocking Cash Flow Management
Coordinate inventory replenishment with sales expectations and available cash.
Explore the restocking modelJob Costing
Track labor, materials, overhead, revenue, and profitability across individual jobs.
Explore the job-costing trackerKPI Dashboard - General Contractor
Monitor project outcomes and company-level performance for a construction business.
Explore the contractor dashboardLending Business or P2P Lending Participant
Forecast loan originations, repayments, defaults, financing, and lender profitability.
Explore the lending modelRoyalty Licensing
Evaluate licensing structures, royalty payments, and economics for both parties.
Explore the royalty modelProject Management
Track project tasks, timelines, budgets, completion, and ownership in Excel.
Explore the project trackerQuestions before you buy
A few useful details.
What does the workbook model?
It models sales and purchases when the transaction, cash movement, and accounting recognition can occur in different months, then links the results across all three financial statements.
Which balance-sheet accounts are included?
The framework includes cash, accounts receivable, inventory, prepaid expenses, accounts payable, unearned revenue, and retained earnings.
How long is the forecast?
The workbook supports a 10-year forecast with monthly calculations and annual views.
Can I change the collection, payment, and recognition timing?
Yes. The model is designed for dynamic cash-receipt, cash-payment, revenue-recognition, and cost-recognition patterns applied to future sales and costs.
Is the workbook editable?
Yes. The formulas and logic are unlocked and editable, and the workbook can also be uploaded to Google Sheets.
Is it included in any bundles?
Yes. It is included in the Accounting Templates bundle and the Super Smart Bundle.
Connect timing to the financial statements
Build a balanced model for sales and purchases on account.
Use flexible cash and recognition patterns, 10-year monthly and annual views, and fully unlocked 3-statement logic in one Excel template. One-time purchase for $45.
