@Charles-Fraichot said in Notepad+++ workflow for Bookkeeping.:
Hello, im a bookkeeper and Im looking into incorporate Notepad+++ into my daily workflow and would love your input. Do you have recommended plug ings or built-in features that works well for bookkeeping? What is the best way to organize and clean bank statements so tools like the free GnuCash importer can read them cleanly and consistently?
The format in which you acquire the bank statements is an important, missing piece in this question. If it is a text-based format (like plain text, HTML, JSON or CSV), then Notepad++, possibly with one or more plugins, might be able to help. If it is not text-based, Notepad++ won’t help.
It looks like GnuCash can import several formats. The only one of those with which I’m familiar is CSV.
Two plugins with CSV capabilities are CSV Lint and CSVQuery. I’m not very familiar with the first and know nothing about the second, but depending on what you need to do, they might help.
I wrote the Columns++ plugin partly because I just hate spreadsheet programs, and I wanted to be able to do simple spreadsheet-like things in Notepad++. Strictly speaking, Columns++ only works well with tab-separated values or files in which columns are physically lined up using spaces; but it can convert from and to CSV files using any separator and a number of specific quoting and escaping rules.
Any tips, tricks or workflow optimizations that would be especially useful for bookkeepers or accountants working with structured data?
I m looking to avoid excel and LibreOffice for this part of my work. Im looking for a text based, precise and reproducible workflow, similar to why many developers rely on notepad+++.
Depending on the input format and what you need to do, Notepad++ might help. However, when you say “precise and reproducible”…
As a text editor with a graphical user interface, Notepad++ is best for problems where you have to look at the source data, decide what needs to be done this time, for this particular data, and then do it. If “precise and reproducible” means you want to work out the rules and transformations in advance and then apply those same rules, consistently and repeatedly, to many batches of (present and future) source data, you would be better advised to look for a scripting solution.