How to Prepare Budgeted Balance Sheet

A budgeted balance sheet shows estimated financial position of a company. By seeing budgeted balance sheet, we can expect same at the end of the financial year. But this is not real balance sheet. When it is not real, then what is the need of preparing  it and why I am here to explain it?

Reason behind this is very clear. It is useful tool for management for decision making. We know management makes almost all type of budget. We should see all these budget' s effect on our future financial position. Future is in our hand. We have made cash budget, material budget, production budget, sales budget, purchase budget and master budget and other departments' budgets. After this, we should make budgeted balance sheet to check whether all budget's effect is positive on on our estimated financial position or not.

Now, I am explaining the steps to make it.

1. Take the Beginning Real Balance Sheet 

For making budgeted balance sheet, we take all the data of real balance sheet of beginning of financial year.

2. Collect the Data of All Budget 

For making budgeted balance sheet, you need to collect the data of various budget like cash budget, purchase budget, finished goods budget, raw material budges, projected sales or purchase deal of fixed assets on credit.

3. Adjustment of Beginning Real Balance Sheet with Data of Different Budgets 

If your hand is good on ms excel, within just few minutes, you can make budgeted balance sheet.

Following are the main adjustments which you should do.

Balance Sheet Items  Adjustment  Basis of Budget
 Cash in Hand and at bank
Take the figure of closing cash in hand balance from cash budget Cash Budget
b) Opening Debtors + New Credit Sale - Cash  Received Sales Budget and Cash Budget
Sundry Creditors
Opening Creditors+ New Credit Purchase  - New Payment Purchase budget and Cash Budget
Finished Stock
Opening Finished Stock + New Production  - New total Sales (Cash+ Credit) Production, Sales and Cash Budgets
Raw Material Stock
Opening Raw Material  Stock + New Purchase ( Cash+Credit)  - New Consumption  Material, production and Cash Budget
Fixed Assets
Opening Balance+ New Purchase - New Sale ( Cost Value)  Cash Budget and Projected Plan Report and Plant Utilization budget
Loan Liabilities
Opening Balance of Loan Liabilities + New Loan Taken - Repayments Cash Budget
h) Accumulated Depreciation Opening Balance Accumulated Depreciation + New Depreciation Overhead Budget
Paid in Capital
Opening Balance of Paid in Capital + Additional Paid in Capital Cash Budget
Retained Earning
Opening Retained Earning + Estimated Net Profit - (Estimated Dividend declared + Estimated Dividend Paid ) Cash Budget and Budgeted Income Statement
General Reserve
Opening Balance of General Reserve + New General Reserve on Specific Rate as per law
Opening Payable Tax + New Payable Tax - (Advance+ TDS) Tax Returns, New Income Tax Law reports, finance budget of Govt. of India and Cash Budget


Comments on this Website
Share above Content to Your Friends


access account accountant Accounting accounting definitions accounting ebook Accounting education accounting procedure accounting process outsourcing Accounting Software advance advertising africa Amalgamation amendments announcements Annuity assets audit auditing Australia B.Com. balance sheet bank Bank reconciliation banking basic accounting BBA benefits best bill black money blog bloggers book keeping bookkeeping Branch Accounting - full tutorial budget Budget variance business businessman CA calculator canada capital capital budgeting career cash cash book cash flow statement Chiense children china class coaching coins college commerce commerce students company computer computer accounting conference Contact vinod kumar corporate accounting cost cost accounting cost center cost centre CPA credit credit card cs currency data Debit and credit debit cards debt debtor degree depletion depreciation documents dollar domain Downloads Dubai e-accounting earning education Education Loans email employee EPF ERP euromoney examination excel excise duty expenses facebook factor of loan fans feature fifo FII fiji finacle finance Financial financial accounting fire insurance flickr flow forensic forex formula france fraud free fun function fund GAAP GDP gdr germany gold goodwill goodwill accounting google google apps google apps google base google buzz google calendar Google docs google finance google fusion tables google talk govt. GST guide health Hindi Hindi Language history holding company How to treat FBT in Tally 9 HRA ICAI ICAWI ICICI Bank IFRS income income statement Income Tax India indian railway Indonesia inflation inflation accounting infographics information inspiration insurance insurance accounting interest international Internet Introduction of Tally 9 inventory investment invoice IT Japan Job costing journal entries Kalculate keyboard kindle kuwait laptop law LBT learning lease lecture ledger leducation Leverage Analysis liabilities lifo linkedin loan logical point loss loss of profit M.Com. m.phil malaysia management accounting manual accounting manufacturing account market marketing mastercard material MBA MCA media migration mobile money ms word ms. excel multi currency in tally 9 Multicurrency Accounting mutual fund national security new and sacrifice ratio new york times new zealand news NGO nonprofit-accounting North Georgia Mountains NPV NSE odbc office oman online application online accounting otcei pakistan parents pay pal pdf pie chart pie chart of income pnb podcast ppf presentation price privacy policy prize money prof. vinod kumar profit profit and loss account project management provision purchase puzzles quickbooks Quote quotes quotes of svtuition rating agency ratio analysis RBI readers real estate rectification of errors remote control reports reserves responsibility accounting retirement revenue Revenue reserves review risk rupees salary sale saudi arabia saving sbi scholarship school SEBI security service tax share share trading Shares shri lanka singapore sms social accounting society solution South Africa stock stock exchange structure student students study subsidiary company svtuition swiss bank tally tally 9 Tally 7.2 Tally 9 Tally.ERP 9 tanzania tax Tax Accounting TDS teacher teaching technology test testimonial testimonials thailand tips trading trading on equity transaction trend trial balance tuition twitter UAE UGC - NET Commerce UK United Arab Emirates university usa valuation VAT Video Voucher and vouching wikipedia working capital youtube
Accounting Education: How to Prepare Budgeted Balance Sheet
How to Prepare Budgeted Balance Sheet
Accounting Education
Not found any lecture VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES Lectures View All RECOMMENDED FOR YOU Category ARCHIVE SEARCH ALL Lectures Not found any lecture match with your request, please help to write it and send it to our email at for making this website free accounting and finance encyclopedia. Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock