Managing Reconciliation Support Sources
Last updated: October 22, 2024
Formatting your spreadsheets
There are two ways you can format your supporting schedules with Numeric. Take a look at our📄 Reconciliation Templatesfor more details!
Single Entity (select the entity from the dropdown from within Numeric)
Add a "Numeric" tab to your existing Spreadsheet(s)
In this tab, and a Column for Account and Column(s) with end of month dates
We will automatically triangulate balances similar to an index-match in Excel based on the account code and end of month date.
Multi-Entity (select “N/A (multi-entity)” from the entity selector in Numeric)
Follow the steps above for Single Entity sheets and add column titled Entity after Account and reference the unique IDs found on the Settings page for each of your entities
Adding a support source
From Account Row
From the Reconcile page, click an account row and add the source from the Reconciliation Sources section in the sidebar
Choose what type of source you'd like to connect
PDF: Let's you drag & drop a bank statement (or link to an existing one uploaded in your file storage system) and automatically parse the ending balance from it!
Spreadsheet: Automatically read a reconciling balance from a formatted Google Sheet or Excel file
When connecting a spreadsheet, provide the spreadsheet link. We will auto-detect the "Numeric" tab, or you can select another formatted tab if named differently.
Select which entity we should apply the source to, or choose multi-entity if you've added an entity column to your source.
Indicate whether you'd like the sheet to roll-forward each time
If checked, we will Sync data from this spreadsheet each period
This is useful for any spreadsheet you have as a "roll-forward", for example an amortizing prepaid expense schedule. When checked, we will look for values in this spreadsheet every period and you only have to link the file once.
If unchecked, we will only sync data from this spreadsheet for the period you are linking it in
From Manage Sources
From the "Manage Sources" page, you can link to spreadsheet sources and assign an entity without having to click down to the account row. This can be useful is linking multiple files at once each month.
From the Reconcile page, click the 3-dots at the top right and select "Manage Sources"
Select "Add Source"
Provide the spreadsheet and select which entity we should apply the source to, or choose multi-entity if you've added the entity column to the source.
Indicate whether you'd like the sheet to roll-forward each time
If checked, we will Sync data from this spreadsheet each period
This is useful for any spreadsheet you have as a "roll-forward", for example an amortizing prepaid expense schedule. When checked, we will look for values in this spreadsheet every period and you only have to link the file once.
If unchecked, we will only sync data from this spreadsheet for the period you are linking it in
Managing connected sources
From the Reconcile page, click the 3-dots at the top right and select "Manage Sources"
All your connected supporting source connected in the period will appear
You can remove a source clicking the trash can icon when hovering on the file name. This will remove the source from the current and future periods. Balances from the source in this period will be cleared.
Viewing sources without balances.
Files that have no balance being pulled in the period your are currently in can be found in the ‘no balance’ tab. If a source has an error, it will likely appear in this tab.
Google Drive Folder Linking
For Google Drive users, we now offer the ability to link folders via Manage Sources which allows you to connect to multiple spreadsheets at once.
For non-Google Drive users, we are looking to add this functionality in the future.
Steps to Link a Folder
Navigate to "Manage Sources" via the three dots at the top right of the reconciliation page.
Select "Add Source".
Paste the link to the Google Drive folder where your spreadsheet reconciliations are saved.
Numeric will load the spreadsheet sources and give you the option to remove any you do not wish to link. We will also highlight whether a file is a multi-entity reconciliation so you can set this up differently on the next screen.
After you've reviewed the spreadsheets to be linked, select "Next".
On the subsequent screen, input the tab name of the leadsheet (e.g., Numeric) and define the entity for the relevant reconciliation. If any spreadsheets have different configurations you can optionally set those up differently before hitting submit.
Once you've input the necessary details, hit "Submit" and Numeric will link to all spreadsheet sources at one time.