Skip to content
Sign in
All product features

Accounting files

Give your accountant a file they can work through.

Choose the records and file format for the task. Generate the output, review its rows and totals, then follow the receiving system’s import process.

Choose the records before choosing the file.

A customer ledger snapshot and a month of invoices are different exports. Set the dataset and relevant period in the accounting workspace.

CeramicPortal · Accounting export workspace
The actual Export Builder selects Sales invoices, Tally XML and an inclusive transaction period, and previews the dataset, output file and included columns.
Export Builder with demo settings. Dataset, format and transaction period are selected before download.Open original
CeramicPortal · Accounting export workspaceOriginal product image · Demo data

Export Builder with demo settings. Dataset, format and transaction period are selected before download.Open original image

CSV file handoff

Rows you can inspect in a spreadsheet.

Sales, purchase, balance and expense datasets offered by the export builder.

This sample is a current customer-balance snapshot. It does not demonstrate an import into another accounting system.

.csv

Customer ledger balances

Generated rows
6
Scope
Opening-balance demo data
Outstanding total
₹5,17,000.00
Download actual CSV

Match the records to the accounting task.

The export builder groups sales, purchases, balances and expenses. Available format and dataset combinations depend on their supported scope and commercial inclusion.

File scope and the checks before an accounting handoff
File formatIncluded record scopeRecipient reviewAvailability and limit
CSV / ExcelThe sales, purchase, ledger-balance and expense datasets listed below.Agree the columns, identifiers and spreadsheet requirements with the recipient.Choose a supported dataset. Ledger balances are current snapshots; a file alone does not prove accounting-import compatibility.
Tally XMLInvoices, sales returns, receipts, purchase bills, supplier payments, customer and supplier balances, and expenses.Confirm the intended Tally version, mappings and a reviewed sample import.Confirm account inclusion. Estimates, challans and purchase orders are not Tally datasets in this builder.
Miracle ExcelThe dedicated finalized sales-invoice profile.Confirm the matching Miracle import profile, version and reviewed result.Confirm account inclusion and pass the readiness check. This profile is not for every record or version.

CSV / Excel

Included record scope
The sales, purchase, ledger-balance and expense datasets listed below.
Recipient review
Agree the columns, identifiers and spreadsheet requirements with the recipient.
Availability and limit
Choose a supported dataset. Ledger balances are current snapshots; a file alone does not prove accounting-import compatibility.

Tally XML

Included record scope
Invoices, sales returns, receipts, purchase bills, supplier payments, customer and supplier balances, and expenses.
Recipient review
Confirm the intended Tally version, mappings and a reviewed sample import.
Availability and limit
Confirm account inclusion. Estimates, challans and purchase orders are not Tally datasets in this builder.

Miracle Excel

Included record scope
The dedicated finalized sales-invoice profile.
Recipient review
Confirm the matching Miracle import profile, version and reviewed result.
Availability and limit
Confirm account inclusion and pass the readiness check. This profile is not for every record or version.
View full comparison table
File scope and the checks before an accounting handoff
File formatIncluded record scopeRecipient reviewAvailability and limit
CSV / ExcelThe sales, purchase, ledger-balance and expense datasets listed below.Agree the columns, identifiers and spreadsheet requirements with the recipient.Choose a supported dataset. Ledger balances are current snapshots; a file alone does not prove accounting-import compatibility.
Tally XMLInvoices, sales returns, receipts, purchase bills, supplier payments, customer and supplier balances, and expenses.Confirm the intended Tally version, mappings and a reviewed sample import.Confirm account inclusion. Estimates, challans and purchase orders are not Tally datasets in this builder.
Miracle ExcelThe dedicated finalized sales-invoice profile.Confirm the matching Miracle import profile, version and reviewed result.Confirm account inclusion and pass the readiness check. This profile is not for every record or version.

Sales

Invoices · Estimates · Challans · Sales returns · Payments received

Purchases

Purchase bills · Purchase orders · Payments made

Balances & expenses

Customer ledger balances · Supplier ledger balances · Expenses

Ledger balances are a current snapshot.

They do not use the transaction date range. For a period-based export, review the selected start and end dates.

Keep a human review between the two systems.

The file is a handoff. It does not synchronize CeramicPortal with accounting software or send two-way updates.

  1. Choose the supported records

    Agree the dataset, format and receiving workflow with the accountant.

  2. Generate the file

    Use the correct period, or the current snapshot for ledger balances.

  3. Review the output

    Compare row counts, identifiers and totals with the source records.

  4. Import and reconcile

    Use the destination’s process, review rejected rows and check what was accepted.

Correct the cause before trying the handoff again.

An unavailable format or validation error needs a specific correction. Keep the selected dataset and context while you review it.

Format not offered
Use only a supported dataset and format combination. Do not rename the file extension to force a match.
Date range needs correction
Check the start and end date; current ledger snapshots do not use a period.
Readiness issue
Review the required product, party, tax or mapping detail named by the actual export result.
Destination rejects rows
Inspect the receiving system’s result before retrying, so accepted rows are not imported again unnecessarily.

Tell us the records your accountant needs.

Bring the destination software, version, required records and an example of the intended import. Confirm the supported handoff before treating a format as included.