SmartHelping / Accounting / Excel & Google Sheets
Accounts Receivable & Payable Template
Keep track of what customers owe you and what you owe vendors. Record invoices and payments, review remaining balances, and see which amounts fall into each aging bucket.
Choose Excel input cards with macros, direct-entry Excel, or Google Sheets. All three entry options are included in one purchase.
Includes the Excel macro version, Excel non-macro version, and Google Sheets version.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
Excel walkthrough
See how invoice entries become useful reports.
Explore the Excel template's invoice entry, receivable and payable tracking, aging reports, and summaries.
Three ways to enter your data
Choose the workflow that fits how you work.
The purchase includes Excel versions with and without macros, plus a dedicated Google Sheets version.
Excel with input cards and macros
Use separate input cards for receivable and payable invoices. VBA buttons support structured invoice entry and updates.
Excel without macros
Enter invoice information directly into the separate receivables and payables database tabs, bypassing the input cards.
Google Sheets
Use the dedicated Google Sheets version for direct database entry, with formulas that support automated tracking and reporting from your entries.
Google Sheets version walkthrough
From invoice detail to monthly summaries
See balances from both sides of the business.
Track collections and vendor payments while keeping the invoice-level detail behind each balance.
Accounts receivable
Review amounts invoiced, money collected, and remaining balances by customer and by invoice.
Accounts payable
Track amounts owed to vendors, payments made, and outstanding balances by vendor and by invoice.
Multiple invoices per customer
Maintain separate invoice records for the same customer, with a customer-level view of amounts owed, paid, and still outstanding.
Fifteen years of monthly summaries
Review monthly owed, paid, and balance summaries over a 15-year tracking period, with individual customer or vendor detail and overall totals.
Three financial charts
Review monthly P&L, running receivable balances, and running payable balances. The charts display one year by default and can be extended for longer views.
Customer and vendor setup
The starting Excel setup accommodates up to 250 customers and 100 vendors. The template can be expanded when more capacity is needed.
Identify overdue balances
Use aging buckets that match your reporting needs.
Aging reports populate from the invoice information entered, showing totals by bucket. The default ranges are:
You can change the day ranges on the Validation tab to suit your own reporting structure.
Keep the aging formulas intact: when clearing example data, preserve the last two columns of each invoice database. Those columns contain the formulas that assign invoices to aging buckets.
A practical tracking routine
Enter invoices, update payments, and review balances.
-
Choose a version and set up your records
Select your preferred entry method, configure customers and vendors, and adjust the aging ranges if needed.
-
Add receivable and payable invoices
Use the Excel input cards or enter records directly into the appropriate database tabs, preserving the aging-formula columns.
-
Keep payments up to date
Update invoice records as customers pay you and as you pay vendors so the reports reflect the latest recorded activity.
-
Review overdue amounts and trends
Use invoice detail, aging reports, monthly summaries, and charts to identify outstanding balances and plan follow-up.
Also included in the accounting collection
Explore more accounting templates in one bundle.
The Accounts Receivable and Payable Template is included in the Accounting Trackers and Calculators Bundle.
Accounting Trackers & Calculators Bundle
Explore templates for financial statements, cash planning, budgeting, receivables, payables, inventory, costing, and reporting.
Explore the bundle →Inventory, costing, and pricing
Connect stock records with cost and cash-flow analysis.
Explore inventory tracking and forecasting, FIFO costing, activity-based costing, pricing, and break-even templates.
Multiple-Location Inventory Tracker
Record inventory and equipment movements, review quantities by SKU and location, and track monthly changes at a selected site.
View template details →FIFO Cost of Goods Sold Calculator
Calculate cost of goods sold by assigning the oldest available purchase-batch costs to sales entered in date order.
View template details →Activity-Based Costing Model
Allocate resource costs through activity pools and cost drivers, then compare product or service unit costs, margins, and target prices.
View template details →Volume Discount Pricing Calculator
Compare volume discounts across starting prices and sales volumes to review revenue, gross profit, and operating income.
View template details →Inventory in a 3-Statement Financial Model
Model inventory purchases, supplier payment timing, and cost of goods sold across the income statement, balance sheet, and cash flow statement.
View template details →Break-Even Financial Model
Calculate sales needed to cover fixed and variable costs or reach a target profit margin, with a five-year forecast and cash flow analysis.
View template details →Inventory Management in Google Sheets
Track inventory movements, balances, weighted-average value, low stock, and upcoming expirations across SKUs and locations in Google Sheets.
View template details →Inventory Reorder Planner
Estimate reorder dates and quantities from current stock, minimum reserves, daily sales, lead times, and order multiples.
View template details →Inventory Forecasting Template
Connect sales forecasts, inventory purchases, arrivals, supplier payment terms, and cash requirements over up to 72 months.
View template details →Operational tracking and reporting
Organize the records behind day-to-day work.
Explore separate tools for database reports, time tracking, recurring tasks, bids, payroll, projects, and job performance.
Google Sheets Database Reporting
Filter database records using multiple field-level pass/fail checks and bring qualifying rows into a summary report.
View template details →Google Sheets Tracking & Reporting Template
Filter database records, move completed work to a separate tab, and summarize monthly sales by salesperson.
View template details →Time Tracker for Hourly Billing
Track time across clients and jobs, calculate billable hours and amounts due, and review weekly activity and billing-status summaries.
View template details →To-Do List Tracker
Set recurring task intervals, record completions, and review upcoming due dates and completion history in Google Sheets.
View template details →Job Bidding Excel Template
Estimate labor, benefits, payroll taxes, insurance, and other direct costs, then calculate a suggested bid using a target margin or cost-based fees.
View template details →Payroll Budget vs. Actual Tracker
Calculate hourly and salaried payroll, compare employee and period totals with budget, and review annualized payroll against expected revenue.
View template details →Job Costing Tracker
Track billed hours and their billing value, filtering by job, crew, or crew member across weekly, monthly, and custom-date reports.
View template details →Construction KPI Dashboard
Compare quoted and actual job results, gross profit, margins, and performance against targets, with monthly trends for up to 24 periods.
View template details →Project Tracker
Schedule projects and tasks on hourly, daily, weekly, or monthly timelines and review completed and outstanding work in a dashboard.
View template details →Assets, financing, and business analysis
Explore supporting investment and forecasting tools.
Compare templates for debt, depreciation, equipment returns, business valuation, lending, royalties, and customer forecasts.
Dynamic Customer Spend & Retention Model
Forecast customer counts and revenue from monthly acquisitions and spending and retention patterns that change with customer age.
View template details →Dynamic Loan Amortization Schedule
Model loans and lines of credit with interest-only periods, amortization, extra principal, early payoff, changing rates, and term conversion.
View template details →Cost Segregation Study Template
Compare baseline and accelerated depreciation schedules to estimate first-year tax savings and the present value of modeled benefits.
View template details →WACC Calculator
Calculate weighted debt and equity costs, then connect WACC to a fifteen-year DCF and valuation sensitivity analysis.
View template details →Equipment Purchase ROI Model
Compare equipment costs with revenue gains, labor savings, and salvage value through ROI, IRR, and NPV sensitivity analysis.
View template details →Depreciation Expense Tracker
Track monthly and annual depreciation expense and aggregate book value for up to 95 assets across a 30-year reporting period.
View template details →Depreciation Recapture Financial Model
Analyze asset cost basis, periodic depreciation, sale proceeds, recapture, and modeled gains or losses in an Excel schedule.
View template details →Lending Business Financial Model
Forecast loan originations, repayments, defaults, financing needs, financial statements, and cash available for distributions over ten years.
View template details →Royalty Licensing Analysis Template
Compare fixed-per-sale and percentage-based royalties using sales forecasts, annual income, present values, sensitivity analysis, and actual results.
View template details →Common questions
Before you start tracking invoices.
Are Excel and Google Sheets both included?
Yes. The $45 purchase includes the Excel macro version, Excel non-macro version, and dedicated Google Sheets version.
Do I have to use macros?
No. The non-macro Excel version lets you enter invoices directly into the receivables and payables database tabs. The Google Sheets version also uses direct entry.
Can I change the aging buckets?
Yes. Edit the day ranges on the Validation tab. The defaults are Current, 1–30, 31–60, 61–90, 91–120, and 121+ days.
How much reporting history is included?
The template includes 15 years of monthly owed, paid, and balance summaries. The three charts display one year by default and can be extended.
How many customers and vendors can I set up?
The starting Excel setup supports up to 250 customers and 100 vendors. Additional capacity can be added by expanding the template.
What should I preserve when deleting example data?
Keep the last two columns in the invoice database tabs. They contain the formulas that determine each invoice's aging bucket.
Does the purchase include two hours of service?
No. The former offer of two free service hours is no longer available.
When can I access the templates?
The included versions are available from the download page immediately after purchase.
Keep outstanding balances visible
Know what is owed, what is paid, and what remains.
Organize receivables and payables with invoice detail, aging reports, and monthly summaries. Need a tailored template? Contact Jason.
