Skip to content

Review the tables in a converted Pastel backup

Last reviewed 16 November 2026 · 6 steps

Open a converted data set, look through its tables, search and filter, and read the checks before you rely on the figures.

Free account

Steps

  1. Open the data set

    In the Pastel converter, press the name of a data set that says Ready. The top of the page shows a summary such as 19 tables, 72 rows, a count of warnings, and Kept until followed by a date. It also shows the financial year start, the periods covered, and whether the trial balance nets to zero. The two downloads sit alongside.

    The review page with the data set name, a "19 tables, 72 rows" summary, a warnings count, two download buttons and the table tabs.Open full size screenshot for step 1
  2. Open a table

    The tabs across the top are Ledger transactions, Customers, Suppliers and Trial balance. Press one. Each table shows its row count and how fully it was read: read in full, partly read, or raw fields only.

    The Customers tab showing its rows, a Search this table box, a Filter button and a Download this table button.Open full size screenshot for step 2
  3. Find other tables under More tables

    Press More tables to open the rest of the backup, each with its row count. Tables with nothing in them say so, for example Inventory, none in this backup. Choose one to open it.

    The More tables menu with options such as Ledger balances, Open item, Tax transactions and Ledger master, each with a row count.Open full size screenshot for step 3
  4. Search a table

    Type in Search this table to narrow the rows. Search reads up to 64 characters and looks in the first 16 columns. The page shows how many rows match.

    A table narrowed by typing Loan into the Search this table box.Open full size screenshot for step 4
  5. Filter by a column

    Press Filter, choose a Filter column, and type a value in Contains. Tables are shown 50 rows at a time. Searches and filters show the first 10,000 matches, so narrow them if you need to see further.

    The Filter panel open with a Filter column list and a Contains box.Open full size screenshot for step 5
  6. Read the checks and warnings

    Look at Check before you rely on it. It lists anything to look at, most serious first, with labels such as Partly read and Warning. Press Technical details for more. All other checks passed shows how many checks were fine. Fix or note each warning before you rely on the figures.

    The Check before you rely on it list with Partly read and Warning items, a Technical details link and All other checks passed (17).Open full size screenshot for step 6

Tips

  • A backup can hold ledger lines older than the last two financial years. They are not shown in the ledger view, and the page tells you how many. Upload a prior-year backup to extract them.
  • Very large tables cannot be sorted. Use search and filter instead.
  • Press Rename to give the data set a clearer name.

If something goes wrong

The page says Unverified: a check failed.
Open Check before you rely on it and read which check failed. The tables are still there to view and download, but treat the figures with care.
The trial balance does not net to zero.
Check the warnings for the reason, then check the figures against Pastel before importing anything.
A table says partly read or raw fields only.
Accounter could not name every field in that table. The data is still in the CSV, but check it before using it.
The data set has disappeared.
Data sets are kept for 30 days from upload and then removed. Upload the backup again if you still need it.