On this page
BlackCat scopes migrations and Excel imports around those questions, whether you are moving from an older Tally environment, another accounting system or structured spreadsheets.
Decide what needs to move
Some businesses need opening balances and outstanding invoices. Others need detailed transaction history, stock quantities or several years of records. These are different projects.
We review the source system, period, companies and outputs before proposing a conversion route. A sample export helps identify the work required without assuming every source record has a direct equivalent.
Excel imports: sample templates or field mapping
TallyPrime documents both predefined Excel samples and mapping templates for supported master and transaction imports. The right approach depends on your file structure and destination requirements.
We review column meaning, dates, identifiers, amounts, ledger references, units and required dependent masters. A spreadsheet that is easy to read is not necessarily ready for a reliable import.
Define the checks before importing
| Workstream | Question to resolve |
|---|---|
| Masters | Are names, groups and identifiers consistent, with duplicates addressed? |
| Opening balances | Which date and approved source report control the conversion? |
| Outstanding invoices | Are references, dates and balances sufficient for the agreed ageing view? |
| Stock | Do units, quantities, values and locations reconcile to the approved source? |
| Transactions | Which voucher types and fields are supported or require a separate conversion? |
| Exceptions | Who corrects rejected or incomplete records, and how is the result recorded? |
Trial, reconcile, then approve
Use a backup or review environment for the trial. Compare agreed totals and inspect representative records, rather than relying only on a row count. Resolve exceptions and obtain approval before the agreed cut-over.
Master-data preparation may be needed first. For a new deployment, connect the migration with the wider Tally implementation plan. Repeated non-standard transfers may need a custom import workflow.
Frequently asked questions
Can you import any Excel file exactly as it is?
No such promise is made. We review the structure, required fields, supported record types and data quality first. The result may require mapping, cleanup, a different export or custom work.
Can bank statements use the same import route?
Do not assume that general master-and-transaction Excel import is the same as bank-statement import or reconciliation. We check your release, file format and intended process separately.
Can all historical information be preserved?
That depends on what the source can export and how it maps to the target. Agree the required history, attachments, references and comparative reports before approving the migration scope.
How do we know the migration is complete?
Define the acceptance evidence at the start: relevant balances, stock totals, outstanding references, sample transactions and resolved exceptions. Your authorised reviewer confirms those outputs against the source.
Show us the source and the outcome you need
Arrange a migration review or contact BlackCat on WhatsApp. Begin with a redacted sample and a description of the required period.
Official references
TallyHelp: Excel samples and mapping templates ↗Reviewed 18 November 2026. Product capabilities, commercial terms and official guidance should be rechecked before implementation.