• Uploading your Balance Sheet Reconciliations

  To use Easy Month End and Xero for your reconciliations: Select any of the cells related to the account you wish to upload a reconciliation for In the side panel upload your reconciliation support Once the document is uploaded, Easy Month End will scan for a number that is equal (/en/article/automatiFew readers

• Automatic reconciliation balance detection

  Easy Month End will look for your 'total' balance with your reconciliation by searching for numbers that are equal to, or very close to the account balance per Xero. This search for your total 'looks' bottom to top, right to left. For the best and fastest results we recommend putting your total reconciliation balance near the bottom right of the document. If you only have one balance that matches you can put it anywhere! If the incorrect cell/balance is selected from your reconciliation/Few readers

• Setting up your Balance Sheet Reconciliations

  Your Balance Sheet will pull directly from Xero once you have connected your Xero account to Easy Month End. Refer to the guide on how to link Xero to Easy Month End. To reconcile your balance sheet accounts, attach the relevant reconciliation support and sign them off: Navigate to Reconciliations on the Navigation bar (https://storage.crisp.chat/users/helpdesk/websFew readers

• Complete & lock your reconciliations

  Once you have completed and reviewed all your reconciliations you can 'lock' the reconciliations. To lock your reconciliations, select the Complete Reconciliation button Once a period is 'locked' all data will be hard coded and links to Xero will be broken to ensure you have robust audit evidence.Few readers

• Remove / reset balance sheet after Excel import

  If you have imported your company's balance sheet via Excel and need a complete reset - for example you loaded the wrong entity's balance sheet up - then don't worry, mistakes happen and we have you covered. To completely undo the last import: Select the Options (three dots) button and then Reset Balance SheetFew readers

• Bulk reconciliation upload

  If you have more than one reconciliation in a single Excel worksheet then you can use the Bulk Upload function to save you having to upload each reconciliation individually. In the reconciliations module, select the three dots , and then Bulk Reconcile Upload your current reconciliation support (or use our template with pre-named tabs) (https://storage.crisp.chat/users/helpdesk/Few readers

• Import your balance sheet via Excel

  Easy Month End allows you to upload your balance sheet accounts and balances via a convenient excel template so you can manage your reconciliations regardless of what ledger you use. In the Reconciliations module select the entity you want to import the balance sheet for from the drop down menu and the Import from Excel option. Download the Excel Balance Sheet Template (https://storage.Few readers

• Update your balance sheet (Excel Upload)

  If you are importing your balance sheet for reconciling into Easy Month End, you can do multiple imports of your balance sheet. This may be useful if there are late changes, last minute journals, or you want to be reconciling as soon as possible. To upload a new balance sheet Select the Options (three dots) button and then Update Balance Sheet You will be redirected to the familiarFew readers

• Balance sheet signoffs

  If you are connected to Xero or Quickbooks your balance sheet will automatically be pulled into Easy Month End ready for you to upload your reconciliations. If you sign off on a reconciliation, and the account balance changes, your sign off will be removed by default. This fact will be captured in the audit log. If you would like your sign offs to remain on your balance sheet even if the account changes, then; Navigate to Settings --Account and deselect option Clear reconciliation sFew readers