Accounting Balance Sheet
What is the best way to reconcile accounts payable or any other balance sheet account?
Trying to reconcile balance sheet accounts at month end.
As the last person Excel is a good start, here’s how I would reconcile A/P, A/R, Cash, Debt (relatively easy accounts to reconcile).
You need to set up a rollforward table in excel at the top of spreadsheet (Row 1) list the following titles for your columns,
Beginning Balance, increases (i.e. what caused this account to increase), decreases (i.e. what caused this account to decrease), ending balance (this should be the month end balance you are reconciling to). Note: Fancier titles may be used.
In the columns under the titles you’ve just listed in row A you can list your various accounts (Column A), the increase catalysts in Column B (cash receipts, increase in A/R, A/P, or new debt, etc.), Column C the cause for account decreases (cash outflows, decrease in A/R b/c of cash receipts, decrease in A/P or debt b/c of cash payments). Column D should be the formula
=A+B-C.
Remember to keep invoices/receipts (to keep track of cash payments, increase in A/P etc.) or what was sent to customers to help keep track of A/R) and bank statements (to help track increase in cash, debt payments, etc.) to help you provide proof of what caused the increases and decreases.
lecture 1: balance sheets part 1
|
|
Wallmonkeys Peel and Stick Wall Decals – Balance Sheet – Removable Graphic WallMonkeys wall graphics are printed on the highest quality re-positionable, self-adhesive fabric paper. Each order is printed in-house and on-demand. WallMonkeys uses premium materials & state-of-the-art production technologies. Our white fabric material is superior to vinyl decals. You can literally see and feel the difference. Our wall graphics apply in minutes and won’t damage your paint or l… |
|
|
The Balance Sheet … |
|
|
QuickBooks Premier Professional Services 2011 – [Old Version] $369.99 Financial software from QuickBooks offers client-based businesses an easy set of accounting, time tracking, and management tools to help the business be more profitable. Whether your company has several departments or locations, you can now track the data separately within a single, easy to access report. Decide who to bill by seeing all clients with unbilled time and e… |
|
|
QuickBooks Online Simple Start [Download] $43.10 Easy to learn and use, QuickBooks Online Simple Start enables you to get started and organize your small business finances quickly. Save time by instantly creating invoices and paying bills with just a few clicks. Simply, log in to a secure website to access your data from any Internet connected PC or Mac or mobile phone. Tax time is a snap with one-click reports. QB Online Simple Start includ… |
|
|
QuickBooks Premier Professional Services 2012 $249.99 QUICKBOOKS PREMIER PROFESSIONAL SERVICES EDITION 2012 RETAIL SML PKG… |
|
|
Accounting For Dummies $12.86 Revised and updated, this beginner`s guide to accounting shows readers how to keep the books for businesses, investments, and taxes, covering a wide range of issues, including income statements and balance sheets, budgeting, managing inventory, profit … |
|
|
Small Business Accounting Simplified (PACKAGE) $18.75 Attorney Sitarz outlines a simplified financial recordkeeping system and offers instructions for filling out a business chart of accounts, invoices, statements, payroll depository records, profit and loss reports, and balance sheets. The fifth edition … |
|
|
How to Read a Balance Sheet (Paperback) $12.76 Crack the code of finance`s big mystery-the balance sheetIn these times of financial anxiety, the ability to keep track of a company`s assets and liabilities is more important than ever, and you can`t do this without a firm grasp of th… |
|
|
The Accounting Cycle $11.21 Written for the beginner, this concise guide maps out the accounting cycle: balance sheets, income statements, ledger transactions, trial balances, and closing entries. |
|
|
MBA Fundamentals Accounting and Finance $15.82 How do you make sense of the accounting report or balance sheet you’ve just been handed? How do these reports help you to understand the company’s performance? How do you use the numbers you have been given to make good business decisions i… |
Accounting News