Appearance

Home Account reconciliation

Account reconciliation

Streamline account reconciliation by validating GL balances, reviewing supporting data, identifying discrepancies, and certifying account accuracy with a clear and reliable audit trail.

By Vishwesh Sarkar

• 19 articles

How can I tell if an account's difference is explained?

Short Answer: Open the account detail and check the 'Unexplained difference' area — if it shows 'Difference fully explained' in green, reconciling items cover the difference. PreRequisites 1. Be signed in. 2. Open the account detail view. Steps 1. Open the account detail for the account you want to check for example 'Bank A/c'. Account detail shows GL balance and Supported balance. 2. Find the box labeled 'Unexplained difference'. If you see the green label 'Difference fully explained', the net reconciling items equal the difference. 3. Also compare the 'Difference' and 'Reconciling items' amounts shown above the 'Unexplained difference' line. The numeric values make it clear whether the reconciling items cover the difference. Troubleshooting 1. Unexplained difference area doesn't show 'Difference fully explained' even though numbers look similar. LikelyCause: There may be rounding differences, or reconciling items are not fully applied. Action: Review the listed reconciling items and supporting items to ensure amounts have been added correctly.

Last updated on Oct 16, 2026

How do I delete a reconciliation?

Short Answer: Open the three-dot menu either on the reconciliation row or next to 'Download' and select 'Delete reconciliation' or 'Delete' if shown to start deletion. PreRequisites 1. Be signed in. 2. Permission to delete reconciliations role-gated. Steps 1. On the Account reconciliations list find the reconciliation row and click the three-dot menu in the Action column. A small menu appears near the row with deletion option. 2. Alternatively open the top-right three-dot menu near 'Download' and select 'Delete reconciliation'. The delete action is triggered. You may be prompted to confirm depending on your environment. Troubleshooting 1. I do not see any delete option in the menus. LikelyCause: You do not have sufficient permissions to delete reconciliations. Action: Ask your admin to grant delete permissions or to delete the reconciliation on your behalf. 2. Delete was selected but reconciliation still appears in the list. LikelyCause: Client or server-side delay, or deletion requires confirmation not shown here. Action: Refresh the page and confirm with your administrator whether deletion succeeded. Note: Menu labels shown include 'Delete reconciliation' top menu and 'Delete' row menu. Deleting a reconciliation is a destructive action; confirm before proceeding.

Last updated on Oct 16, 2026

How do I download the original trial balance file?

Short Answer: Open 'View trial balance' and click the 'Download original file' button in the modal to save the uploaded file to your device. PreRequisites 1. Be signed in. 2. Access to the trial balance for that reconciliation. Steps 1. Open the three-dot menu near 'Download' and choose 'View trial balance'. Trial balance modal appears. 2. Click the 'Download original file' button at the bottom-right of the modal. Browser downloads the original uploaded file for example 'Demo.xlsx'. Troubleshooting 1. Clicking 'Download original file' does not start a download. LikelyCause: Browser blocked the download or there is a network issue. Action: Allow downloads for this site, check your network, or try again in a different browser. 2. Downloaded file is not the expected version. LikelyCause: The file on the reconciliation may have been replaced or the wrong file was uploaded. Action: Confirm the uploader shown in the modal and ask them to re-upload the correct file if needed.

Last updated on Oct 16, 2026

How do I open a reconciliation to view its accounts and details?

Short Answer: On the Account reconciliations page click the reconciliation row or the 'View' link in Action, then click an account for example 'Bank A/c' to open its detail view. PreRequisites 1. Be signed in. 2. Access to the Account reconciliations page. Steps 1. Open Account reconciliations from the main menu so the list loads. You see the list of reconciliations with the table and top summary cards. 2. In the row for the reconciliation example 'Demo' click the reconciliation name or the 'View' link in the Action column. Reconciliation overview opens showing progress cards and the accounts table. 3. In the accounts table click the account row you want to inspect for example 'Bank A/c'. Account detail modal or panel opens showing balances, supporting items, reconciling items, comments and history. Troubleshooting 1. Clicking the row or 'View' does nothing. LikelyCause: Page did not fully load or you are not signed in / lack access. Action: Refresh the page, confirm you are signed in, then try again. If still blocked, contact your account admin to confirm access. 2. I can open the reconciliation but cannot open a specific account. LikelyCause: There are no account details created for that row or the row is 'Not started'. Action: Confirm the account has been prepared or assigned; check the Status column for 'Not started' before expecting details. Note: Use the 'Search reconciliations...' box and 'Add filter' to find a specific reconciliation.

Last updated on Oct 16, 2026

How do I reopen a certified account?

Short Answer: Open the certified account, click the three-dot menu and select 'Reopen reconciliation', enter a required reason, then click 'Reopen'. PreRequisites 1. Be signed in. 2. You can view the certified account. 3. Permission to change account status if role-gated. Steps 1. Open the reconciliation and then open the certified account example: click 'Bank A/c'. Account detail opens and shows the green 'Certified' badge and certification info. 2. Click the three-dot menu in the account header and choose 'Reopen reconciliation'. The 'Reopen certified account?' modal appears. 3. In the modal enter a Reason in the text area placeholder: 'e.g. Balance discrepancy found after certification.' The reason is recorded and the 'Reopen' button becomes enabled. 4. Click 'Reopen'. The account returns to 'In progress' and the action is recorded in History. Reason is preserved. Troubleshooting 1. 'Reopen' button is disabled greyed out. LikelyCause: The 'Reason' field is empty. It is required. Action: Enter a reason in the text area; the modal shows 'Required — reason will be recorded in the history.' 2. I don't see 'Reopen reconciliation' in the menu. LikelyCause: You may not have permission or the account is not actually certified. Action: Confirm the account shows the 'Certified' badge and ask your admin to grant reopen permissions if needed. Note: Modal title shown: 'Reopen certified account?' and the modal includes the note 'Required — reason will be recorded in the history.'

Last updated on Oct 16, 2026

How do I share a reconciliation with someone?

Short Answer: Open the three-dot menu next to 'Download' and choose 'Share' to open sharing options. PreRequisites 1. Be signed in. 2. Access to the reconciliation. Steps 1. On the reconciliation overview click the three-dot menu located next to the 'Download' button. A menu opens that includes 'Share'. 2. Click 'Share'. Sharing options open. Troubleshooting 1. No 'Share' option in the menu. LikelyCause: Your account may not have sharing permissions or you opened a different menu. Action: Confirm you clicked the three-dot menu next to 'Download' and contact your admin to request sharing rights if needed.

Last updated on Oct 16, 2026

How do I view the trial balance for a reconciliation?

Short Answer: Open the three-dot menu near the top-right next to 'Download' and select 'View trial balance' to open the Trial balance modal. PreRequisites 1. Be signed in. 2. Access to the reconciliation. Steps 1. On the reconciliation overview locate the top-right area with the 'Download' button and click the three-dot menu. A menu opens showing options including 'Share', 'View trial balance', and 'Delete reconciliation'. 2. Click 'View trial balance' from the menu. Trial balance modal opens showing the uploaded file and rows. 3. Review the trial balance modal contents file name, uploader, date/time, rows and statuses. You can see rows like 'Bank A/c' with amounts and 'Added' status badges. 4. Close the modal when done by clicking 'Close' or the modal X. You return to the reconciliation overview. Troubleshooting 1. 'View trial balance' is not present in the menu. LikelyCause: You may not have permission to view trial balance or you opened a different menu. Action: Confirm you opened the three-dot menu next to 'Download' and ask your admin to grant view access if needed. 2. Trial balance modal opens but rows are missing or show '0 rows skipped'. LikelyCause: The uploaded file may have been processed into accounts differently or some rows were skipped during upload. Action: Check the file upload details in the modal file name and '0 rows skipped' and contact the uploader if the file needs re-uploading.

Last updated on Oct 16, 2026

I don't see menu options like 'View trial balance', 'Share', or 'Delete reconciliation' — what should I check?

Short Answer: If menu items are missing, confirm you opened the correct three-dot menu and that you are signed in with required permissions; if needed, ask your admin. PreRequisites 1. Be signed in. 2. Open the reconciliation overview page. Steps 1. Confirm you clicked the three-dot menu in the correct location next to the 'Download' button or the per-row ellipsis. You see the menu that contains 'Share', 'View trial balance', and 'Delete reconciliation'. 2. If the option is still missing, refresh the page and try again. Any transient UI errors are cleared. 3. If options remain missing, contact your admin to confirm you have the necessary permissions for the requested action. Admin confirms or updates your role/permissions. Troubleshooting 1. Menu doesn't open at all. LikelyCause: Browser extension or page scripting blocked the menu, or there is a UI error. Action: Disable extensions that block page scripts, try a different browser, or refresh the page. 2. Option exists but is greyed out. LikelyCause: Action is role-gated or requires a specific account state for example only certified accounts show 'Reopen'. Action: Check the account's status for example 'Certified' and request proper permissions from your admin if needed.

Last updated on Oct 16, 2026

Where do I find supporting items, reconciling items, and the reconciliation note for an account?

Short Answer: Open the account detail and scroll to the 'Supporting items', 'Reconciling items', and 'Reconciliation note' sections shown on the account page. PreRequisites 1. Be signed in. 2. Open the specific account detail example: 'Bank A/c'. Steps 1. Open the account detail for example by clicking 'Bank A/c'. Account detail is visible with header and summary cards. 2. Scroll down to the 'Supporting items' section to view linked source items such as 'Bank statement' and their supported balance. You see supporting items listed with amounts for example 'Bank statement ₹1,10,000'. 3. Scroll further to 'Reconciling items' to view items that adjust the supported balance and the net reconciling total. Reconciling items and a progress bar or amounts are visible. 4. Look for 'Reconciliation note' to see any free-text note. It may show 'No note added.' You can read any reconciliation note or add one if your permissions allow. Troubleshooting 1. No supporting or reconciling items are listed. LikelyCause: No supporting items or reconciling items have been added for this account. Action: Confirm whether a preparer has uploaded supporting documents or added reconciling items, or check other accounts. Note: 'Supporting items', 'Reconciling items', and 'Reconciliation note' headings are visible in the account detail.

Last updated on Oct 16, 2026

How do I add a supporting item to an account?

Short Answer: Open the account, click '+ Add supporting item', fill 'Description' and 'Amount', choose 'Add' or 'Reduce', then click 'Add item' to update the Supported balance. PreRequisites 1. You have the reconciliation and account open. 2. Description and Amount for the supporting item. Steps 1. Open the account by clicking the account row in the Balance Sheet. Account detail modal opens showing GL balance and Supported balance. 2. Click '+ Add supporting item' in the Supporting items area. The 'Add supporting item' modal opens. 3. Enter a 'Description' (required) and 'Amount' (required). Both fields are filled and valid. 1. Select 'Add' or 'Reduce' under 'Effect on supported balance' and click 'Add item'. The supporting item appears in the Supporting items list and 'Supported balance' updates. Troubleshooting 1. 'Add item' button is disabled or greyed out. LikelyCause: One or more required fields ('Description' or 'Amount') are empty or invalid. Action: Fill the required 'Description' and 'Amount' fields. Amount must be a valid number. 2. Supported balance did not change as expected. LikelyCause: You selected the wrong 'Effect on supported balance' (Add vs Reduce) or entered amount with the wrong sign. Action: Edit or remove the supporting item and re-add with the correct 'Add' or 'Reduce' selection. Note: Description and Amount fields show a red asterisk indicating they are required.

Last updated on Oct 16, 2026

How do I assign a preparer or reviewer to account(s)?

Short Answer: Select one or more accounts, then use 'Assign preparer' or 'Assign reviewer' from the top action bar, or set Preparer/Reviewer inside the account detail. PreRequisites 1. You are on the Balance Sheet page 2. Users to assign are available in the dropdowns Steps 1. In the Balance Sheet select the account(s) by checking the box next to each account. The top action bar shows '1 account selected' and action buttons. 1. Click 'Assign preparer' or 'Assign reviewer' in the top action bar and choose the user to assign. Selected preparer/reviewer is applied to the selected account(s). 1. Alternatively, open an account and use the 'Preparer' and 'Reviewer' dropdowns in the account header to assign directly. Preparer/Reviewer names appear in the account header and in the list columns. Troubleshooting 1. Assign buttons do not appear or are inactive. Likely Cause: No accounts are selected. Action: Select one or more account checkboxes first, then use the top action buttons. 2. Reviewer/Preparer dropdown shows 'Not assigned' and no names. Likely Cause: No users available in the dropdown for this reconciliation or role restrictions. Action: Check with your team/admin to confirm which users should be available for assignment. Note: Assigned names show in the 'Preparer' and 'Reviewer' columns on the Balance Sheet list once applied.

Last updated on Oct 16, 2026

How do I certify an account that still has an unexplained difference?

Short Answer: As the Reviewer, open the account, click 'Certify', read the '₹... remains unexplained' warning, and click 'Certify anyway' to mark it Certified. PreRequisites 1. You must be the assigned Reviewer for the account 2. Account has been submitted for review or is open in review Steps 1. Open the account detail that is 'Awaiting review'. Account shows 'Awaiting review' and summary panels. 2. Click the 'Certify' button at the bottom right of the account modal. A 'Certify account?' confirmation modal opens. 3. Read the warning ('₹2,40,000 remains unexplained...') and, if you accept it, click 'Certify anyway'. Account status becomes 'Certified' in the Balance Sheet list. Troubleshooting 1. I don't see the 'Certify' button. Likely Cause: You are not the assigned Reviewer or the account is not in a reviewable state. Action: Check the 'Reviewer' field in the account header (it should list the assigned reviewer) or ask the assigned reviewer to certify. 2. I want to reduce the unexplained difference before certifying. Likely Cause: Unexplained difference is > 0. Action: Add supporting items or upload supporting file to increase Supported balance before certifying (use '+ Add supporting item' or 'Upload file' in Supporting items). Note: The 'Certify account?' modal explicitly warns that the unexplained difference will remain visible if you proceed.

Last updated on Oct 16, 2026

How do I edit or delete the uploaded trial balance file?

Short Answer: On the New account reconciliation page click 'Edit' to reconfigure file mappings or 'Delete' to remove the uploaded trial balance. PreRequisites 1. A trial balance file is already uploaded and visible in the Trial balance box Steps 1. Open New account reconciliation where the uploaded file token is shown. You see the uploaded file listed under 'Trial balance' with 'Edit' and 'Delete' actions. 2. To edit mappings, click 'Edit' to open 'Configure file' and change 'Header row', 'Account name', or closing balance settings, then click 'Save & apply'. Mappings updated and applied to the reconciliation. 3. To remove the file, click 'Delete' on the trial balance token. The trial balance is removed from the reconciliation page. Troubleshooting 1. Unable to delete the uploaded file. Likely Cause: The reconciliation may already be started or the UI prevented deletion for this state. Action: If deletion is blocked, check whether the reconciliation is in progress or contact your administrator/support for assistance. Note: Use 'Edit' to fix column mapping issues before starting reconciliation; deleting will remove the uploaded file from this reconciliation.

Last updated on Oct 16, 2026

How do I find, filter, and download accounts from the Balance Sheet?

Short Answer: Use 'Search accounts...' to find by name, click 'Assigned to me' or '+ Add filter' to narrow results, select rows to act on, and use 'Download' to export. PreRequisites 1. Open the Balance Sheet page Steps 1. Open the Balance Sheet. You see summary cards (Total accounts, To prepare, etc.) and the accounts table. 2. Type in 'Search accounts...' to locate an account by name. Matching rows filter in the table. 3. Click 'Assigned to me' or '+ Add filter' to apply additional filters. Table updates with the selected filters. 4. To export, click 'Download' at the top-right of the Balance Sheet. Download action is initiated. Troubleshooting 1. Search returns no results. Likely Cause: A filter is active or search term is misspelled. Action: Clear filters (use 'Assigned to me' or '+ Add filter') and check the search term spelling. Note: Column headers show sortable controls (small arrows) to reorder the table by GL balance, Supported, etc.

Last updated on Oct 16, 2026

How do I map columns when configuring the trial balance file?

Short Answer: Open 'Configure file' for the uploaded file, choose 'Header row', set 'Account name' (and 'Account code' if available), pick closing balance handling (Single balance column or Separate debit and credit columns), then click 'Save & apply'. PreRequisites 1. A trial balance file uploaded and visible in the Trial balance box 2. File contains header row and account names Steps 1. On the New account reconciliation page click 'Edit' next to the uploaded trial balance. 'Configure file - filename' modal opens. 2. In the Configure file modal set the 'Header row' to the row containing your column headers. Preview rows align with the header row you selected. 3. Select the column for 'Account name' (and 'Account code' if you have one). Account names map correctly in the preview. 4. Under 'Closing balance' choose either 'Single balance column' or 'Separate debit and credit columns'. If you pick Separate, select the 'Debit' and 'Credit' columns. Closing balances are configured and the preview updates. 5. Click 'Save & apply' to save the mappings. Mappings saved and the reconciliation preview uses the mapped columns. Troubleshooting 1. Preview cells show 'Click to generate' instead of values. Likely Cause: The corresponding column has not been mapped. Action: Choose the correct column for 'Account name' or add the missing column mapping in the modal. 2. Balances look incorrect after mapping. Likely Cause: Incorrect closing balance method chosen (Single vs Separate debit/credit). Action: Reopen Configure file, choose the correct 'Closing balance' option and select proper Debit and Credit columns if using 'Separate debit and credit columns'. Note: The Configure file modal shows the hint 'Closing balance = Debit - Credit' when you choose Separate debit and credit columns.

Last updated on Oct 16, 2026

How do I move to the next account while reviewing and how do I return an account to the preparer?

Short Answer: In an open account modal use 'Next account >' to navigate to the next account; use 'Send back' to return the account to the preparer. PreRequisites 1. An account modal open (account detail view) Steps 1. Open an account detail from the Balance Sheet. Account modal opens with header and status. 2. Click 'Next account >' (top-left of the modal) to go to the next account in sequence. The next account's detail opens in the modal. 3. If you are the reviewer and want to return the account to the preparer, click 'Send back' at the bottom of the modal. 'Send back' action is triggered (the account is returned to the preparer workflow). Troubleshooting 1. 'Next account' or 'Send back' is not visible. Likely Cause: You may not have the required role or the account is not in a relevant state. Action: Verify your assigned role or the account status; contact your workflow owner if needed. Note: The modal header shows navigation control 'Next >' and status badges (e.g., 'Awaiting review' or 'Not started').

Last updated on Oct 16, 2026

How do I submit an account for review?

Short Answer: Open the account, click 'Submit for review', choose a 'Reviewer' in the modal, then click 'Submit anyway' to send it for review. PreRequisites 1. You have completed preparation steps for the account 2. A Reviewer is available to select Steps 1. Open the account detail (click the account row in the Balance Sheet). Account modal opens. 2. Click 'Submit for review' at the bottom right of the account modal. A 'Submit for review?' confirmation modal opens. 3. In the 'Submit for review?' modal review the summary and pick a 'Reviewer' from the dropdown. Reviewer is selected in the moxdal. 4. Click 'Submit anyway'. Account status becomes 'Awaiting review' (yellow status shown). Troubleshooting 1. I can't submit because the Reviewer field is empty. Likely Cause: A Reviewer must be selected before submitting. Action: Select a Reviewer in the 'Submit for review?' modal, then click 'Submit anyway'. 2. A warning says '₹2,40,000 remains unexplained'. Likely Cause: The account has an unexplained difference. Action: Either add supporting items/upload a support file to reduce the unexplained difference, or proceed by clicking 'Submit anyway'. Note: The 'Submit for review?' modal shows a summary (Supported balance, Difference, Reconciling items, Unexplained difference) before submission.

Last updated on Oct 16, 2026

What information is shown in an account's detail view?

Short Answer: Account detail shows 'GL balance' (From trial balance - read-only), 'Supported balance' (Sum of supporting items), 'Difference', 'Reconciling items', 'Unexplained difference', 'Supporting items', 'Attachments' and 'Reconciliation note'. PreRequisites 1. Open the account detail by clicking an account row in the Balance Sheet. Steps 1. Open the account detail by clicking the account row. The account modal appears showing the top summary and status. 2. Read the GL balance panel (labelled 'GL balance' with subtext 'From trial balance - read-only') and the Supported balance panel (labelled 'Supported balance' with subtext 'Sum of supporting items'). You can see GL and Supported balances and their subtext. 3. Check the 'Difference', 'Reconciling items' and 'Unexplained difference' lines and review 'Supporting items', 'Attachments' and 'Reconciliation note' sections below. All key reconciliation fields are visible for review and action.

Last updated on Oct 16, 2026

Why does the UI display “₹2,40,000 remains unexplained”? Also, can I still submit or certify the report if this amount remains unexplained?

Short Answer: That message means 'Unexplained difference' is non-zero. You may still submit or certify, but the unexplained difference will remain visible in the reconciliation. PreRequisites 1. An account with a non-zero Unexplained difference. Steps 1. Open the account detail and check 'Difference' and 'Unexplained difference'. You can see the amount flagged in red and the explanation message. 2. To reduce the unexplained difference, add supporting items via '+ Add supporting item' or 'Upload file' in the Supporting items area. Supported balance increases and Unexplained difference reduces if amounts match. 3. If you choose not to resolve it, you can proceed: in 'Submit for review?' click 'Submit anyway' or as Reviewer click 'Certify' → 'Certify anyway'. The account moves to 'Awaiting review' or becomes 'Certified' while the unexplained difference remains visible. Troubleshooting 1. Unexplained difference remains unchanged after adding items. LikelyCause: Effect (Add/Reduce) selected incorrectly or incorrect amounts were entered. Action: Edit or remove the supporting item and re-add it with the correct 'Effect on supported balance' and amount sign. 2. I still see the warning in the submit/certify modal. LikelyCause: Unexplained difference was not fully resolved. Action: Either resolve the remaining difference or proceed with 'Submit anyway' / 'Certify anyway' knowing the difference will be shown in the reconciliation. Note: The product shows an explicit warning in the confirmation modals; proceed only if you accept that the unexplained amount will remain visible.

Last updated on Oct 16, 2026