Bank Reconciliation Statement

Reconciliation of Bank accounts
Reconciling the Company's Bank Accounts with the Banker's Statement is a fundamental and regular task of Accounting. Our first presentation of this facility aims to tackle two issues.
First, there should be the ability to 'check back' the correctness of the reconciliation. This has been done, by marking the 'Bank Date' against the voucher. For instance, if you have issued a cheque on 8th April, which was ultimately cleared by your Bank on 19th April, - you would set the 'Bank Date' for the voucher to be 19th April. This means, that when you next need to 'check back' whether the entry made by you is correct, you will only need to verify the Bank Statement of the 19th.
Second, that you should be able to 'recover' the reconciliation as of any date. This is of crucial importance to Auditing. The Bank Reconciliation is one of the pre-requisites of Auditing and verification of the correctness of accounts at the year end. However, it is not a 'real-time' task – in the sense, that it is not done by the auditor's on the first day of the next year. This means, that the reconciliation made on 31st Mar, should be 'viewable' even in August, - by when almost all the cheques would have subsequently been marked as reconciled. This has again been achieved using the concept above.
Bank Accounts may have a different 'Starting Date' for reconciliation purposes. When you create a Bank Account, you are requested to give an 'Effective Date for Reconciliation' just before the Opening Balance. Normally, this would be the 'Books Beginning from' date itself. However, you could have imported data from a previous version of Tally or from any other system (where the reconciliation process was not available or was different. In that case, you may not wish to reconcile the bank account with your bank statements from the very beginning. Give the date from which you want the reconciliation facility to be activated. Then, previous entries will not appear for reconciliation, but will be taken as a reconciled Opening Balance.
A quick experiment with Reconciliation will show you what is meant. Here is how you go about it:

Bring up the monthly summary of any Bank Book. (You could do this from the Balance Sheet, Trial Balance, or Display/Account Books/Bank Books, and selecting a Bank).
Bring you cursor to the first month (typically April), and press Enter. This brings up the Vouchers for the month of April. Since this is a Bank Account, an 'additional' button F5: Reconcile will be visible on the right. Press F5.
The display now becomes an 'Edit' screen in 'Reconciliation' mode. The primary components are:A column for the 'Bankers Date'
The 'Reconciliation' at the bottom of the screen, showing:
Balance as per Company Books
Amounts not reflected in Bank
Balance as per Bank
The Balance as per Company Books reflects your Balance as on the last date (in our example case, 30- Apr).
The Amounts not reflected in Bank is the debit and credit sums of all those vouchers whose Bank Date is either BLANK, or GREATER than 30-Apr (i.e. these vouchers have not yet been reflected in the Bank Statement).
The Balance as per Bank is the Nett effect of your Book Balance offset by the amounts not reflected in the Bank – which should equal the balance in the Bank Statement. (Of course, some variation may persist due to entries made in the Bank Statement which you have not yet entered in your Books – but since you WILL definitely enter them, and only then print your reconciliation, it will ultimately reflect the correct balance).
You will find, as you mark off the individual vouchers by setting the 'Bank Date', that the Reconciliation at the bottom of screen keeps reflecting those changes instantly. When you are finished, press Ctrl+A (or press Enter as many times as necessary to skip over the unmarked vouchers), and accept the screen. (If your screen has a largish number of vouchers it may take some time to complete the acceptance – be patient).
The next time you come for reconciliation, you will be presented only with those vouchers which remain unreconciled. Thus, the task keeps becoming simpler.



(It may be possible, that due to an error of entry made earlier, you wish to see those vouchers which are already marked as reconciled – so that you may modify their marking. To do this, press F12:Configure. In case you have already pressed a few keys BEFORE pressing F12, Tally will query whether you wish to discard changes made so far, if any, by asking 'Quit Y/N'. Simply press Y – and the configuration screen will appear. Here, specify whether you wish to see the reconciled vouchers also).
Remember , to print your Reconciliation, just press Alt+P!

COMMENTS

Comments on this Website
.
Share above Content to Your Friends



Name

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
false
ltr
item
Accounting Education: Bank Reconciliation Statement
Bank Reconciliation Statement
Accounting Education
http://www.svtuition.org/2008/04/bank-reconciliation-statement.html
http://www.svtuition.org/
http://www.svtuition.org/
http://www.svtuition.org/2008/04/bank-reconciliation-statement.html
true
2410664366776677676
UTF-8
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 vinod@svtuition.org 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