Use the template to provide answers Cash Budget
Quarter	Quarter 1	Quarter 2	Quarter 3	Quarter 4	Total
Month	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun
Cash Inflow
Accounts Receivable
Total Inflow
Cash Outflow
Advertising
Insurance
Utilities
Rent
Wages
Office expenses
Bank Fees
Interest on loan
GST payable
Total Outflow
Net Inflow/Outflow
Quarter Inflow/Outflow
Opening Cash
Net Inflow/Outflow
Closing Cash
GST Budget
Quarter	Quarter 1	Quarter 2	Quarter 3	Quarter 4	Total
Month	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun
GST collected	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Less GST Paid on:
Advertising
Insurance
Utilities
Rent
Office expenses
Total GST paid
Total GST Payable
Quarter GST Paid
Income Statement Budget
Quarter	Quarter 1	Quarter 2	Quarter 3	Quarter 4	Total
Month	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun
Revenue
Less Operating Expenses
Net Profit
Quarter Net Profit
Balance Sheet Budget
Current Assets
Cash
Accounts Receivable
Non-Current Assets
Equipment
Accumulated Deprn- Equip
Total Assets
Current Liabilities
GST Payable
Non-Current Liabilities
Loan
Net Assets
Capital
Opening Captial
Net Profit
Revenue Budget		Revenue Budget		Revenue Budget		Revenue Budget
Month	July	Aug	Sept	Quarter		Month	Oct	Nov	Dec	Quarter		Month	Jan	Feb	Mar	Quarter		Month	Apr	May	June	Quarter
Sales	$27,225	$36,465	$32,505	$96,195		Sales	$36,465	$18,233	$9,116	$63,814		Sales	$9,116	$18,233	$9,116	$36,465		Sales	$9,116	$9,116	$18,233	$36,465		$232,939
Total Revenue	$27,225	$36,465	$32,505	$96,195		Total Revenue	$36,465	$18,233	$9,116	$63,814		Total Revenue	$9,116	$18,233	$9,116	$36,465		Total Revenue	$9,116	$9,116	$18,233	$36,465		$232,939
Accounts Receivable Collection Schedule		Accounts Receivable Collection Schedule		Accounts Receivable Collection Schedule		Accounts Receivable Collection Schedule
Month	July	Aug	Sept	Quarter		Month	Oct	Nov	Dec	Quarter		Month	Jan	Feb	Mar	Quarter		Month	Apr	May	June	Quarter		Year Collection Total
Sales	$27,225	$32,819	$29,255	$89,298		Sales	$36,465	$16,410	$8,204	$61,079		Sales	$9,116	$16,410	$8,204	$33,730		Sales	$9,116	$8,204	$16,410	$33,730
GST	$2,723	$3,282	$2,925	$8,930		GST	$3,647	$1,641	$820	$6,108		GST	$912	$1,641	$820	$3,373		GST	$912	$820	$1,641	$3,373
Sales Incl GST	$27,225	$36,465	$32,505	$96,195		Sales Incl GST	$36,465	$18,233	$9,116	$63,814		Sales Incl GST	$9,116	$18,233	$9,116	$36,465		Sales Incl GST	$9,116	$9,116	$18,233	$36,465
Collections						Collections						Collections						Collections
May	$770			$770		Aug	$3,647			$3,647		Nov	$1,823			$1,823		Feb	$1,823			$1,823
June	$4,400	$1,100		$5,500		Sept	$13,002	$3,251		$16,253		Dec	$3,646	$912		$4,558		Mar	$3,646	$912		$4,558
July	$13,340	$10,890	$2,723	$26,953		Oct	$17,868	$14,586	$3,647	$36,100		Jan	$4,467	$3,646	$912	$9,025		Apr	$4,467	$3,646	$912	$9,025
Aug		$17,868	$14,586	$32,454		Nov		$8,934	$7,293	$16,227		Feb		$8,934	$7,293	$16,227		May		$4,467	$3,646	$8,113
Sept			$15,927	$15,927		Dec			$4,467	$4,467		Mar			$4,467	$4,467		June			$8,934	$8,934
Total Collections	$18,510	$29,858	$33,236	$81,604		Total Collections	$34,516	$26,771	$15,407	$76,694		Total Collections	$9,937	$13,492	$12,672	$36,100		Total Collections	$9,937	$9,025	$13,492	$32,454		$226,852
Accounts Receivable		Accounts Receivable		Accounts Receivable		Accounts Receivable
Month	July	Aug	Sept	Quarter		Month	Oct	Nov	Dec	Quarter		Month	Jan	Feb	Mar	Quarter		Month	Apr	May	June	Quarter
Opening Balance	$ 6,270	$ 14,559	$20,581	$ 6,270		Opening Balance	$ 18,981	$ 19,835	$ 10,465	$ 18,981		Opening Balance	$ 3,354	$ 2,078	$6,454	$ 3,354		Opening Balance	$ 2,625	$ 1,166	$ 893	$ 2,625
Credit Sales inc GST	$ 27,225	$ 36,465	$ 32,505	$ 96,195		Credit Sales inc GST	$ 36,465	$ 18,233	$ 9,116	$ 63,814		Credit Sales inc GST	$ 9,116	$ 18,233	$ 9,116	$ 36,465		Credit Sales inc GST	$ 9,116	$ 9,116	$ 18,233	$ 36,465
Collections	$ 18,510	$ 29,858	$ 33,236	$ 81,604		Collections	$ 34,516	$ 26,771	$ 15,407	$ 76,694		Collections	$ 9,937	$ 13,492	$ 12,672	$ 36,100		Collections	$ 9,937	$ 9,025	$ 13,492	$ 32,454
Discounts	$ 272	$ 365	$ 325	$ 962		Discounts	$ 365	$ 182	$ 91	$ 638		Discounts	$ 91	$ 182	$ 91	$ 365		Discounts	$ 91	$ 91	$ 182	$ 365
Bad Debts	$ 154	$ 220	$ 545	$ 919		Bad Debts	$ 729	$ 650	$ 729	$ 2,109		Bad Debts	$ 365	$ 182	$ 182	$ 729		Bad Debts	$ 547	$ 273	$ 273	$ 1,094
Closing Balance	$ 14,559	$ 20,581	$ 18,981	$ 11,157		Closing Balance	$ 19,835	$ 10,465	$ 3,354	$ 3,354		Closing Balance	$ 2,078	$ 6,454	$ 2,625	$ 2,625		Closing Balance	$ 1,166	$ 893	$ 5,178	$ 5,178		$ 22,313