{"product_id":"general-ledger-reconciliation-excel-template-accounting-bookkeeping-spreadsheet","title":"General Ledger Reconciliation Excel Template | Accounting \u0026 Bookkeeping Spreadsheet","description":"\u003cp class=\"MsoNormal\"\u003eSimplify your reconciliation workflow with this \u003cb\u003eGeneral Ledger Reconciliation Excel Template\u003c\/b\u003e. This reusable spreadsheet provides a structured way to organize reconciliation items, track adjustments, and review the resulting adjusted balance in one convenient worksheet. \u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003eDesigned for bookkeepers, accountants, small business owners and finance professionals, the template includes dedicated areas for account information, starting balance, deposits in transit, outstanding checks, unrecorded deposits, checks and electronic transfers.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003eBuilt-in calculations maintain the adjusted balance as reconciliation entries are recorded, helping create a clear and organized workflow for recurring reconciliation tasks.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eWhat’s Included\u003c\/b\u003e\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e• General Ledger Reconciliation Excel Worksheet\u003cbr\u003e• Bank Name \u0026amp; Bank Phone Fields\u003cbr\u003e• Account Number \u0026amp; Month Ending Fields\u003cbr\u003e• Prepared By \u0026amp; Date Fields\u003cbr\u003e• Reviewed By \u0026amp; Date Fields\u003cbr\u003e• Starting Balance Section\u003cbr\u003e• Deposits in Transit Tracking\u003cbr\u003e• Outstanding Checks Tracking\u003cbr\u003e• Deposits Not Recorded Tracking\u003cbr\u003e• Checks \/ Electronic Transfers Not Recorded Tracking\u003cbr\u003e• Automatic Running Adjusted Balance\u003cbr\u003e• Total Adjusted Balance\u003cbr\u003e• Disclaimer \/ Reference Tab\u003cbr\u003e• Reusable Excel Spreadsheet\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eKey Features\u003c\/b\u003e\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eOrganized Reconciliation Layout\u003c\/b\u003e\u003cbr\u003eKeep important reconciliation information together in one structured worksheet.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eAutomatic Calculations\u003c\/b\u003e\u003cbr\u003eBuilt-in formulas calculate the running adjusted balance based on the information entered.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eMultiple Reconciliation Categories\u003c\/b\u003e\u003cbr\u003eRecord deposits in transit, outstanding checks and other applicable unrecorded transactions.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eAccount \u0026amp; Period Information\u003c\/b\u003e\u003cbr\u003eDedicated fields make it easy to identify the applicable bank account and reconciliation period.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003ePrepared \u0026amp; Reviewed By Fields\u003c\/b\u003e\u003cbr\u003eRecord preparation and review information directly within the worksheet.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eReusable Excel Format\u003c\/b\u003e\u003cbr\u003eSave separate copies and reuse the spreadsheet for future reconciliation periods.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eHow It Works\u003c\/b\u003e\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003e1. Add Account Details\u003c\/b\u003e\u003cbr\u003eEnter the applicable bank, account, month and preparation information.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003e2. Enter the Starting Balance\u003c\/b\u003e\u003cbr\u003eAdd the starting balance for your reconciliation period.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003e3. Record Reconciliation Items\u003c\/b\u003e\u003cbr\u003eEnter applicable deposits, outstanding checks and unrecorded transactions.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003e4. Review the Adjusted Balance\u003c\/b\u003e\u003cbr\u003eUse the automatically calculated adjusted balance to review your reconciliation.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eUseful For\u003c\/b\u003e\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e• Small Business Owners\u003cbr\u003e• Bookkeepers\u003cbr\u003e• Accountants\u003cbr\u003e• Finance Professionals\u003cbr\u003e• Freelancers\u003cbr\u003e• Entrepreneurs\u003cbr\u003e• Office Administrators\u003cbr\u003e• Accounting Departments\u003cbr\u003e• Business Finance Organization\u003cbr\u003e• Recurring Reconciliation Workflows\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eWhy Use This Template?\u003c\/b\u003e\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Professional and organized layout\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Built-in adjusted balance calculations\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Multiple reconciliation categories\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Easy-to-follow spreadsheet structure\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Reusable for recurring workflows\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Keeps reconciliation information together\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Microsoft Excel spreadsheet format\u003cbr\u003e\u003cspan style=\"font-family: 'Segoe UI Symbol',sans-serif; mso-bidi-font-family: 'Segoe UI Symbol';\"\u003e✓\u003c\/span\u003e Instant digital access\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eDigital Product\u003c\/b\u003e\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003eThis listing is for a \u003cb\u003edigital Microsoft Excel spreadsheet template\u003c\/b\u003e.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003eNo physical product will be shipped.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003eYou will need compatible spreadsheet software to open and use the file. Enter your own information into the applicable fields and save separate copies for different reconciliation periods as required.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003ePlease review the included disclaimer\/reference information before use.\u003c\/p\u003e\n\u003cp class=\"MsoNormal\"\u003e\u003cb\u003eInstant Digital Download • Excel Spreadsheet • Reusable Template • Automatic Calculations\u003c\/b\u003e\u003c\/p\u003e","brand":"My Template Vault","offers":[{"title":"Default Title","offer_id":58536241889663,"sku":null,"price":1.98,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1010\/1381\/5679\/files\/GeneralLedgerReconciliationExcelTemplate_1.png?v=1790465633","url":"https:\/\/mytemplatevault.com\/products\/general-ledger-reconciliation-excel-template-accounting-bookkeeping-spreadsheet","provider":"My Template Vault","version":"1.0","type":"link"}