because I’m doing expense sheets for tax time and I’m horribke at keeping up so once I year I just pull a csv of my bank account and make a spread sheet and sort expenses. but because places have insane memos there’s like 1000 unique transactions so I can’t batch easily
hledger can use regex to import csv into its accounting format with a rule file. The rule file is just a simple list of conditionals and the resulting entries.
If you know regex and are good at scripting in bash, hledger is fucking based. Importing csvs doesn't require any scripting per se, but obviously, where a system is cli / text based, you can do a lot with stdout.
For example, I have one account for receivables. All invoices are dumped into it. Clients are "payees". They don't have subaccounts.
If I want to get reports on all clients balances / transactions, I pull the list of all payees, grep for client number patten, read the result and recursively run each "payee" back into hledger one at a time. So I can treat clients like they each have an account without having to have 500 subaccounts.
The only thing that throws most people for a loop is double entry accounting in cash, not accrual based business, e.g. receivables vs revenues. I still double entry account, because it's easier in most systems — cash accounting usually requires extra steps to avoid the default double entry systems — but my reports are effective cash, e.g. I never look at revenues.
If you need help, don't hesitate to ask. It's actually pretty easy.
You may also want to look into splitting your bank account. I have an operating, a payroll, and a Marchant (cc) account.
Checks get deducted from assets:accounts_receivable and go into assets:undeposited_funds. This is payee by payee. Once deposited, the entire amount goes from undeposited_funds to assets🏦operating. Remember, you really don't deposited separate checks into an account. You sell (negotiate) checks in bulk to your bank in exchange for the deposit amount.
CC payments are deducted from accounts_receivable and go directly into the merchant account. When funds are moved to operating, that's one big, separate transaction from merchant to operating, similar to the checks.
You can also organize by separating expenses by their tax attributes using tags or codes, e.g. util for utilities, int for interest, etc. This can all be done with a rule file. So later you can just pull by code or tag to get your totals for your return. Stupid easy.
I also keep a separate journal for each bank account, one for payments, one for invoices, etc. and use a main that just has a list of includes. This keeps everything tidy.
Whether data is easy to work with really depends on how he data you're pulling is organized from the jump. Throwing everything into one account is just a mess. It does take some planning and foresight to avoid that headache. For example, I read the hledger manual over and over on the john for about a week to plan how I would organize given its features. I ran some test journals too, so I could make sure I got it before going into "production."
I have the issue everyone pays differently. It all hits the same account, but comes from different sources. Like most customers do check, some do cc, some do random third party payment processors, and some (very few) do cash.
I typically do cash accounting for the books because, again, im lazy and just track everything at the end of the year lol. But if you ask me about business I'll tell you where accrual counting puts us 😏.
Double entry accounting confuses me, but this year my method is going to break because there are more moving parts. So, im going to have to figure it out. I'm going to have to look into these, I have to build some system that saves me from quickbooks.
I'm incorporated, but am on the list of non-exempt entities, law firms have to be 1099'd, whether incorporated or not. Gross on the 1120s always exceeds the 1099s, since not everyone sends them, so I don't worry myself too much with them.
The only problem I've had to date was that I took a small loss one year during covid, but the IRS scanner flipped it into a gain, which cost me $7k that I'm still fighting over. I had to lend money in to to cover rent, etc too. Fuck the government.
So far I haven't been dealing with enough transactions for manually sorting to be an issue. It's around 2.5K transactions a year and like 2000 of those are just me, so I really only have to sort 500-700 transactions or so from like 10 different vendors/suppliers. But we are getting more the complexity is growing to where this year it's going to be a nightmare to do it this way again.
Also, how you liking that 1099-k
I have like goddamn 25 1099s, they just kept coming in the mail lmao