FREE MANUAL BILLING PLANNER · AUSTRALIA
Prepare one billing run across repeat clients
Different clients, different cutoffs, different purchase orders. Keep approved work together only when the billing instructions match, and see every row held for review.
This plans a manual workflow. It does not create, import, send or schedule invoices. Your drafts and account history are not accessed.
Choose a filled example, then use your own records
cycle:weekly / monthly / per_job. Weekly cutoff: 1 Monday–7 Sunday. Monthly cutoff: 1–28 or last. per_job cutoff: use -. Each billing_group must have one customer and bill-to instruction; create separate groups for separate purchase orders.
work_status:complete / planned / cancelled; bill_via:direct / platform; already_invoiced:yes / no. approval_ref is your manual evidence reference. Exact unique work references; dates YYYY-MM-DD. AUD amounts on one consistent tax basis, up to two decimals. Maximum 500 rows / 100,000 characters per table.
The planner processes these tables in browser code without uploading or saving them to an account. Your browser may restore form values. Separate existing page/CTA analytics does not receive table contents. Downloaded CSVs are planning records, not invoices or successful invoice exports.
What the period rule actually does
At 15 October 2026, a Sunday-cutoff weekly group uses 5–11 October; a month-end group uses 1–30 September. October work remains visible as open-period work, while August work is shown as older backlog. Neither is declared unbillable. Review both separately instead of losing them in a total. A per-job group uses service dates through the planning date, with one proposed document group per unique work reference.
“Ready” only means the entered fields passed these planning checks. It does not verify completion, approval, prior invoicing, customer identity or entitlement. Change a field and the prior result is cleared, so downloads cannot silently use an old answer.
11 COMPLETE FICTIONAL CASES
Different work decisions, with expected results
Every case uses 15 October 2026 as its planning date. The fixed summaries below do not change when you edit the form.
FICTIONAL WORKED CASE
Weekly cleaner: approved visits only
Two completed visits have confirmation references; a third is still planned.
- Rows ready for manual preparation
- 2
- Suggested document groups
- 1
- Entered ready-work amount
- A$260.00
- Rows excluded / needing review
- 1
Planning date: 15 October 2026. Values are sample working records, not actual customers or income.
View both filled tables
Billing instructions
billing_group,customer_key,bill_to,cycle,cutoff CLEAN-A,C-A,Example Client A,weekly,7
Work register
billing_group,customer_key,work_ref,service_date,work_status,approval_ref,amount,bill_via,already_invoiced CLEAN-A,C-A,V-01,2026-10-06,complete,OK-01,120,direct,no CLEAN-A,C-A,V-02,2026-10-09,complete,OK-02,140,direct,no CLEAN-A,C-A,V-03,2026-10-10,planned,OK-03,120,direct,no
Billing-group CSV · Work-register CSV · Filled review output
FICTIONAL WORKED CASE
Sole trader: weekly and monthly clients
A weekly customer is ready; a monthly customer has one old backlog entry and one current open-period entry.
- Rows ready for manual preparation
- 1
- Suggested document groups
- 1
- Entered ready-work amount
- A$180.00
- Rows excluded / needing review
- 2
Planning date: 15 October 2026. Values are sample working records, not actual customers or income.
View both filled tables
Billing instructions
billing_group,customer_key,bill_to,cycle,cutoff W,C-A,Example Weekly Client,weekly,7 M,C-B,Example Monthly Client,monthly,last
Work register
billing_group,customer_key,work_ref,service_date,work_status,approval_ref,amount,bill_via,already_invoiced W,C-A,W-01,2026-10-07,complete,OK-01,180,direct,no M,C-B,M-OLD,2026-08-25,complete,OK-02,220,direct,no M,C-B,M-NEW,2026-10-06,complete,OK-03,240,direct,no
Billing-group CSV · Work-register CSV · Filled review output
FICTIONAL WORKED CASE
Contractor: match the instructed customer
A service-site name is not substituted for the principal customer key. The mismatched row stays outside the plan.
- Rows ready for manual preparation
- 1
- Suggested document groups
- 1
- Entered ready-work amount
- A$350.00
- Rows excluded / needing review
- 1
Planning date: 15 October 2026. Values are sample working records, not actual customers or income.
View both filled tables
Billing instructions
billing_group,customer_key,bill_to,cycle,cutoff ORDER-7,PRINCIPAL,Example Principal Co,per_job,-
Work register
billing_group,customer_key,work_ref,service_date,work_status,approval_ref,amount,bill_via,already_invoiced ORDER-7,PRINCIPAL,WORK-01,2026-10-07,complete,WO-7,350,direct,no ORDER-7,SITE-OWNER,WORK-02,2026-10-08,complete,WO-8,250,direct,no
Billing-group CSV · Work-register CSV · Filled review output
Read the related invoice guide · Read the related invoice guide
FICTIONAL WORKED CASE
Consultant: separate purchase-order groups
One client has two explicit billing groups. They remain separate even with the same billing name and weekly cutoff.
- Rows ready for manual preparation
- 2
- Suggested document groups
- 2
- Entered ready-work amount
- A$750.00
- Rows excluded / needing review
- 0
Planning date: 15 October 2026. Values are sample working records, not actual customers or income.
View both filled tables
Billing instructions
billing_group,customer_key,bill_to,cycle,cutoff PO-A,C-A,Example Client A,weekly,7 PO-B,C-A,Example Client A,weekly,7
Work register
billing_group,customer_key,work_ref,service_date,work_status,approval_ref,amount,bill_via,already_invoiced PO-A,C-A,SESSION-A,2026-10-06,complete,PO-A,300,direct,no PO-B,C-A,SESSION-B,2026-10-08,complete,PO-B,450,direct,no
Billing-group CSV · Work-register CSV · Filled review output
FICTIONAL WORKED CASE
Electrician: missing work-order confirmation
Completing work does not fill in a missing confirmation reference. The second row requires a check.
- Rows ready for manual preparation
- 1
- Suggested document groups
- 1
- Entered ready-work amount
- A$180.00
- Rows excluded / needing review
- 1
Planning date: 15 October 2026. Values are sample working records, not actual customers or income.
View both filled tables
Billing instructions
billing_group,customer_key,bill_to,cycle,cutoff E,C-E,Example Electrical Client,weekly,7
Work register
billing_group,customer_key,work_ref,service_date,work_status,approval_ref,amount,bill_via,already_invoiced E,C-E,E-01,2026-10-05,complete,WO-1,180,direct,no E,C-E,E-02,2026-10-07,complete,,220,direct,no
Billing-group CSV · Work-register CSV · Filled review output
FICTIONAL WORKED CASE
Photography: future delivery date
A confirmed completed entry dated after the planning date is still excluded for investigation. A label alone cannot make a future event ready.
- Rows ready for manual preparation
- 1
- Suggested document groups
- 1
- Entered ready-work amount
- A$600.00
- Rows excluded / needing review
- 1
Planning date: 15 October 2026. Values are sample working records, not actual customers or income.
View both filled tables
Billing instructions
billing_group,customer_key,bill_to,cycle,cutoff PHOTO,C-P,Example Photo Client,per_job,-
Work register
billing_group,customer_key,work_ref,service_date,work_status,approval_ref,amount,bill_via,already_invoiced PHOTO,C-P,DEL-01,2026-10-09,complete,DEL-OK-1,600,direct,no PHOTO,C-P,DEL-02,2026-10-20,complete,DEL-OK-2,400,direct,no
Billing-group CSV · Work-register CSV · Filled review output
FICTIONAL WORKED CASE
Freelancer: duplicated work reference
Two revisions share the same work reference; both are held rather than counted as separate approved work.
- Rows ready for manual preparation
- 1
- Suggested document groups
- 1
- Entered ready-work amount
- A$300.00
- Rows excluded / needing review
- 2
Planning date: 15 October 2026. Values are sample working records, not actual customers or income.
View both filled tables
Billing instructions
billing_group,customer_key,bill_to,cycle,cutoff F,C-F,Example Freelance Client,weekly,7
Work register
billing_group,customer_key,work_ref,service_date,work_status,approval_ref,amount,bill_via,already_invoiced F,C-F,REV-01,2026-10-06,complete,REV-A,200,direct,no F,C-F,REV-01,2026-10-07,complete,REV-B,200,direct,no F,C-F,REV-02,2026-10-09,complete,REV-C,300,direct,no
Billing-group CSV · Work-register CSV · Filled review output
FICTIONAL WORKED CASE
Construction: already-invoiced stage
The first stage is manually marked invoiced. Only the separately approved later stage enters preparation. This is not a progress-claim entitlement calculation.
- Rows ready for manual preparation
- 1
- Suggested document groups
- 1
- Entered ready-work amount
- A$1500.00
- Rows excluded / needing review
- 1
Planning date: 15 October 2026. Values are sample working records, not actual customers or income.
View both filled tables
Billing instructions
billing_group,customer_key,bill_to,cycle,cutoff BUILD,C-B,Example Builder Client,per_job,-
Work register
billing_group,customer_key,work_ref,service_date,work_status,approval_ref,amount,bill_via,already_invoiced BUILD,C-B,STAGE-1,2026-10-03,complete,CERT-1,1000,direct,yes BUILD,C-B,STAGE-2,2026-10-09,complete,CERT-2,1500,direct,no
Billing-group CSV · Work-register CSV · Filled review output
Read the related invoice guide · Read the related invoice guide
FICTIONAL WORKED CASE
Pet care: direct clients and platform billing
The direct-client visit enters preparation; the platform-billed visit is held for its separate arrangement. The tool does not infer platform terms.
- Rows ready for manual preparation
- 1
- Suggested document groups
- 1
- Entered ready-work amount
- A$80.00
- Rows excluded / needing review
- 1
Planning date: 15 October 2026. Values are sample working records, not actual customers or income.
View both filled tables
Billing instructions
billing_group,customer_key,bill_to,cycle,cutoff PET,C-P,Example Pet Owner,weekly,7
Work register
billing_group,customer_key,work_ref,service_date,work_status,approval_ref,amount,bill_via,already_invoiced PET,C-P,PET-DIRECT,2026-10-06,complete,OWNER-OK,80,direct,no PET,C-P,PET-PLATFORM,2026-10-08,complete,PLATFORM-REF,90,platform,no
Billing-group CSV · Work-register CSV · Filled review output
FICTIONAL WORKED CASE
Repeat client: cancelled visit and zero-charge entry
A regular client still has exceptions. Cancelled and zero-amount entries are visible for separate review, not added to a routine invoice.
- Rows ready for manual preparation
- 1
- Suggested document groups
- 1
- Entered ready-work amount
- A$100.00
- Rows excluded / needing review
- 2
Planning date: 15 October 2026. Values are sample working records, not actual customers or income.
View both filled tables
Billing instructions
billing_group,customer_key,bill_to,cycle,cutoff R,C-R,Example Repeat Client,weekly,7
Work register
billing_group,customer_key,work_ref,service_date,work_status,approval_ref,amount,bill_via,already_invoiced R,C-R,R-01,2026-10-06,complete,OK-1,100,direct,no R,C-R,R-02,2026-10-07,cancelled,OK-2,100,direct,no R,C-R,R-03,2026-10-08,complete,OK-3,0,direct,no
Billing-group CSV · Work-register CSV · Filled review output
FICTIONAL WORKED CASE
Quote handover: confirmed work, not planned scope
A quote reference is kept with completed work. Planned scope remains excluded even if it has an acceptance reference. No quote is automatically converted.
- Rows ready for manual preparation
- 1
- Suggested document groups
- 1
- Entered ready-work amount
- A$250.00
- Rows excluded / needing review
- 1
Planning date: 15 October 2026. Values are sample working records, not actual customers or income.
View both filled tables
Billing instructions
billing_group,customer_key,bill_to,cycle,cutoff Q,C-Q,Example Quoted Client,per_job,-
Work register
billing_group,customer_key,work_ref,service_date,work_status,approval_ref,amount,bill_via,already_invoiced Q,C-Q,Q-DONE,2026-10-06,complete,QUOTE-OK,250,direct,no Q,C-Q,Q-PLANNED,2026-10-09,planned,QUOTE-OK,500,direct,no
Billing-group CSV · Work-register CSV · Filled review output
Resolve the held rows, then prepare the actual invoice
Open the original invoice tool, select the verified customer and manually enter the final scope and amounts. Check the preview before exporting PDF/image. Saved customers and basic history are not paid-exclusive. Frequent users may find existing VIP export allowances and selected-history CSV/file packs useful; occasional use can remain free. No automation, accounting integration or payment collection is promised by this planner.
Try the invoice tool nowCheck invoice files, references and customer-copy fields · Check output handoffs and capability fit
Reference and limits
Official guidance describes clear invoice records and consistent billing schedules. The calendar grouping and fictional examples here are our manual planning aid, not government certification or tax advice. business.gov.au.