All posts

Using Parserje with AutoCount, Bukku and Excel

Parserje is not accounting software and is not trying to be. It prepares the statement so the software you already use gets clean data. Here is how that fits with the three tools people ask about most.

With Excel or Google Sheets

The download is an ordinary .xlsx file, so it opens anywhere with no conversion. Sort by amount to find the big items, filter the description column to pull out one supplier, or run a pivot table to see where the month went. For a personal budget, that is the whole job.

With AutoCount

Many desktop AutoCount installations have no bank statement upload at all, so entries get keyed in by hand from the PDF. That is the exact job Parserje was built for.

Put the workbook on one side of the screen and AutoCount on the other, and key from rows instead of from a PDF you keep scrolling and losing your place in. Two habits help: sort the rows so similar entries are keyed together, and add a tick column so you always know where you stopped. If your edition does accept an import file, copy the workbook, rearrange the columns to match its template, and import the copy. Keep the original exactly as it came.

With Bukku and other cloud accounting

Cloud systems usually accept a bank import, and each wants its columns in a particular order. The routine is the same: copy the workbook, reorder the columns to match the template your system gives you, save as CSV if it asks for CSV, and import that copy. Working on a copy means the original still stands as a record of what the statement actually said.

Then check your keyed data against the statement

The most useful habit comes after the keying. Export the month back out of your accounting system to Excel and compare it against the Parserje workbook: same number of rows, same total debit, same total credit. A missing entry or a transposed figure shows up in seconds instead of at year end.

  1. Statement PDF
  2. Parserje workbook
  3. Keyed into your system
  4. Exported back to Excel
  5. Compared against the workbook
The round trip. The workbook you keyed from is the yardstick you check against.

The workbook is both the sheet you key from and the yardstick you check against later, which is why it is worth keeping the original untouched.

Today you do that comparison yourself in Excel. We are building it into Parserje as a return trip, so you can bring the exported file back to the page that produced the workbook and have the differences pointed out for you.

Haven't converted a statement yet? Start here. Keying into accounting software raises the stakes on accuracy, so the habits that make a conversion trustworthy are worth reading before you begin.

Questions people ask

Can I import a bank statement into AutoCount?

Many desktop AutoCount installations have no bank statement import at all, so entries are keyed in by hand. The workbook gives you clean rows to key from. If your edition does accept an import file, copy the workbook, rearrange the columns to match its template, and import the copy.

Does Parserje do bank reconciliation?

No. It is the step before your accounting work, not a replacement for it.

Can Parserje check what I keyed in?

Not yet inside the tool. For now, export the month back out of your system to Excel and compare it against the Parserje workbook: same row count, same total debit, same total credit.

More questions on the Parserje FAQ

Convert your bank statement to Excel

Drop in your PDFs. Parserje reads them, checks the figures against the statement, and tells you what it found.

Convert Statements