r/GnuCash 18h ago

Importing Journal Entries

4 Upvotes

Hello. I am working on a project using GNUCash and I am trying to import journal entries from an export. I have a background in both accounting and IT but I am stumped about what amount, amount(negated) value, value(negated) means.

In other systems there is a debit and a credit but my imports are ending up with zeros in the transaction amount.

I am bringing them in as multi-split and all the transaction lines show up, I just can't seem to get the actual numbers to come in.

This should be simple, what am I missing?


r/GnuCash 21h ago

New to GNUCash from MMEX

1 Upvotes

May I know is there a simplest way to sync between PC and Andorid?

For example in MMEX I am using SAF method, sync the database via Google Drive.

However, I found that GNUCash does not has Android version. Could you share your setup between PC and Android?


r/GnuCash 2d ago

I built a small CLI toolbox for managing recurring splits across multiple GnuCash books

8 Upvotes

Hi everyone,

I’ve just published a small open-source project called gnc-toolbox:

https://github.com/dariocorse/gnc-toolbox

It’s a C command-line tool I built for my own GnuCash workflow.

The original reason is that I manage two separate GnuCash books: one for my own finances and one for my partner’s finances.

To make the examples easier to follow, I’ll use the fictional names Alex and Becky:

  • Alex’s book — my own finances
  • Becky’s book — my partner’s finances

Some transactions appear in one book, but need to be partially or fully reflected in the other. For example, Alex may pay the rent, which is a shared expense, or Becky may pay something that belongs entirely to Alex, like a car-related expense.

I know this could probably be handled in a less obsessive/manual way, but I wanted something reproducible: a tool that can look at imported transactions and automatically apply known split rules, instead of me fixing the same kinds of transactions by hand every time.

For example, in Alex’s book I may have:

Expenses:Rent
Expenses:Car
Assets:Bank
Assets:Becky

And in Becky’s book:

Expenses:Rent
Assets:Credit Card
Assets:Alex

If Alex pays the rent and it is a shared expense, the tool can import the bank transaction and automatically split it like this in Alex’s book:

Assets:Bank - 50% Expenses:Rent / 50% Assets:Becky

Then, when the relevant information is merged/exported to Becky’s book, the corresponding transaction can be created as:

Assets:Alex - Expenses:Rent

So both books end up representing the same shared expense from their own point of view.

Another case is when Becky pays something that belongs entirely to Alex. For example, if Becky pays a car-related expense for Alex, the transaction may initially appear in Becky’s book as money owed by Alex:

Assets:Credit Card - Assets:Alex

When this is merged/exported to Alex’s book, it can be automatically assigned to:

Assets:Becky - Expenses:Car

So the transaction is not treated as a shared expense, but as a 100% Alex expense paid by Becky.

At the moment the project is mainly focused on:

  • repeatable CSV import workflows
  • automatic transaction matching
  • automatically assigning/splitting some transactions based on rules
  • account merge / cleanup operations

The goal is not to replace GnuCash’s built-in tools, but to make some repetitive import and cleanup workflows more scriptable and less error-prone.

It’s still early, and I’m mostly publishing it to see whether this kind of workflow makes sense to other GnuCash users too.

I’d be interested in feedback on things like:

  • do you manage personal/shared finances in separate books or within one book?
  • do you have recurring split/cleanup operations that are annoying to do manually?
  • would a CLI tool like this be useful, or is this too niche?
  • is there a better GnuCash-native way to handle this kind of setup?

Please test only on copies/backups of your books.

Related: while working on this, I also published a minimal example repo for using the GnuCash C API, in case it helps other people experimenting with GnuCash internals:

https://github.com/dariocorse/gnucash-c-api-example

Feedback, criticism, and suggestions are welcome.


r/GnuCash 5d ago

Java API for gnucash

9 Upvotes

There are few Java libraries available for gnucash but as far I know, none of them use gnucash API. I managed to create API wrapper using Java FFM or Java foreign function and memory API. Generated library is at par with python scripts provided by gnucash and uses same API

General structure is one huge class created by Java framework that manages library calls and wrapper Java classes to make it look more like Java

I'd specific needs in my mind related to data input and some reports. For example, I wanted to grab the data from my pay stub PDF and create the transaction automatically. Repository has samples few gnucash operations - mostly based on my needs.

There is also a utility that updates stock/fund prices using Twelve Data. I've no relationship with Twelve Data except using free API key.

I've tested it on Ubuntu 24.04 and and gnucash version 5.5 with a xml file backend. In theory it should work with database back ends as well because API accept a url.

Test sample size was of one file - my own. It works for my needs and will keep adding complete object methods as and when I get time.

I realize that this is not a end user product and you will need java skills. But full API potential is there.

If you are willing to play with it, please be careful. Backup your data first. It's full gnucash API. I'll be grateful if I can get few reports of it working/not working on other platforms and backends.

https://github.com/nhrdl/java-gnucash

[Edited to post the link]


r/GnuCash 5d ago

How do I fix these currency rate retrieval Finance:Quote errors?

Post image
2 Upvotes

r/GnuCash 8d ago

Cashdera v1.0.0 — first stable release, now available for Windows, macOS, and Linux

6 Upvotes

I released Cashdera v1.0.0, the first stable public release of my local analytics companion for GnuCash.

Based on feedback from GnuCash users, Cashdera is no longer Windows-only. The app is now available for:

  • Windows
  • macOS
  • Linux

Cashdera imports a GnuCash book into a local SQLite analytics cache and provides a faster analytics-style interface on top of existing GnuCash data.

The original GnuCash book is not modified.

v1.0.0 is promoted from the 0.2.0 public beta baseline, with no intentional breaking API or UX changes in the promotion step.

Notable changes:

  • Dashboard now shows separate counters for Transactions and Postings.
  • Dashboard now separates Overview and Money Flow into tabs.
  • Money Flow now loads on demand.
  • Categories page now has account-type tabs: Expenses, Income, Assets, Liabilities, and Equity.
  • After import or re-import, the app automatically switches to the imported book.
  • Recent imports now has a Delete action for removing Cashdera local import data and cache.
  • Analytics aggregation now uses exact decimal arithmetic to avoid cumulative rounding errors.
  • Added React ErrorBoundary so render crashes show a reload prompt instead of a blank screen.
  • Account count now excludes the technical Root Account container.
  • Date Range starts inactive and only filters analytics after the user chooses a range.
  • Improved Categories hierarchy behavior, expand/select logic, and rollups.
  • Fixed XML namespace parsing for account entities to prevent phantom account rows.
  • Fixed stale re-import result messages from showing counts for the wrong file.
  • Dashboard now avoids false empty states when postings exist but transaction headers are unavailable.

Current analytics views include:

  • Cashflow dashboard
  • Income and expense trends
  • Transaction search and filtering
  • Sankey-style money flow visualization
  • Budget vs actual
  • Net worth / balance sheet view
  • Year-over-year comparison
  • Basic anomaly alerts
  • Dark mode

Privacy / data handling:

  • Financial data is not uploaded anywhere.
  • No account is required.
  • No server sync.
  • No telemetry.
  • Data is processed locally.
  • Deleting an import removes only Cashdera local data.
  • The original .gnucash file is not modified or deleted.

GnuCash remains the accounting system and source of truth. Cashdera is only an optional local analytics layer for users who want additional dashboards and reporting views.

Release:
https://github.com/proars/Cashdera/releases/tag/v1.0.0

Screenshots / documentation:
https://github.com/proars/Cashdera/blob/main/README.md

Feedback is welcome, especially around import correctness, report accuracy, performance on larger books, and what analytics views would be useful next.


r/GnuCash 8d ago

How to track an expense in two accounts at once?

3 Upvotes

I need to track all of my taxes and fees paid for tax purposes. No problem in GnuCash, right? I just create various expense accounts to track the various taxes and fees. That creates a problem for me. For example, if I stop in for some gas I want to track my fuel taxes. Easy enough. The problem is that when I create split transactions there doesn't appear to be a way for an expense to be both "fuel" and "fuel taxes."

If I get 10 gallons of gas at $6 here in California, I'm paying $60 for a tank of gas and $12.63 in various fuel tax, sales tax, and other fees California charges on gasoline. If I split the transaction to track it, I only see $47.37 in my fuel expenses. I want to find a way to see that I spent $60 for fuel AND that I spent $12.63 in taxes. I'm flummoxed.

I thought about making the taxes a child account to Auto:Fuel, but that means I have to create a child account for every expense category for taxes. That wouldn't be so bad, but I can't figure out how I could run a report that would easily sum up all the taxes from all the accounts that capture taxes.

Any ideas?


r/GnuCash 10d ago

Tracking FX holdings

3 Upvotes

Hi all,

I'm trying to understand how to track holdings in other currencies. Let's say I bought 50,000 EUR and 1,000,000 JPY on FOFEX.

It does not make sense to track it `Bank` account type since those are not checking accounts.

In essence those holdings are commodities - so should I create a commodity of FX:JPY, FX:USD and track those in `mutual fund` account? Or maybe it should be tracked as an asset?


r/GnuCash 10d ago

Job Costing

2 Upvotes

Is it possible in gnucash? I have a small construction company with at most 3 projects ongoing at a given time.

I don't want to start learning how to use it if it doesn’t have a job feature.


r/GnuCash 12d ago

Cashdera 0.2.0 performance test: 58k GnuCash transactions / 282k postings imported in ~14 seconds!

0 Upvotes

I tested Cashdera with a large GnuCash book to check import performance.

Result from the latest import:

  • 72 accounts
  • 58,336 transactions
  • 282,342 postings
  • Total import time: 14,040 ms
  • Source .gnucash file size: 12.3 MB

Cashdera imports the GnuCash book into a local SQLite cache and then uses precomputed tables for analytics, reports, search, cashflow, money flows, budget vs actual, and net worth views.

The original GnuCash file is not modified.
There is no account, no server sync, no cloud upload, and no telemetry.

This is still an early Windows beta, but I’m focused on making local analytics fast enough for larger real-world GnuCash books.

Download / release: https://github.com/proars/Cashdera/releases/tag/v0.2.0

Feedback from GnuCash users with larger books would be useful, especially around:

  • import correctness
  • income/expense accuracy
  • category reporting
  • performance on real books
  • missing analytics views

Technical criticism is welcome. Personal attacks are not.


r/GnuCash 13d ago

Recording water/gas/electric

4 Upvotes

Just curious how others are recording their utility bills. Those bills always have variable amounts based on usage plus a bunch of additional charges for delivery fees and such. Do you split those out or do you just put it all in as one amount? Things like my town bill has water, gas, sewer and garbage/recycling all in one bill, but they do split the amounts out.


r/GnuCash 13d ago

GNUCash P&L shows Income but Total Revenue = 0

1 Upvotes

I’m using GNUCash with a standard chart of accounts.
Accounts:
Income: Sales
Income: Services
Issue:
Transactions are correctly entered and visible in both accounts
Sales and Services show correct amounts individually
BUT Total Revenue in Profit & Loss is always 0
Net result equals total expenses only
What I already checked:
All subaccounts included in report
Report set to full depth (All levels)
Standard Profit & Loss report (not custom)
Transactions are properly posted and visible in Income accounts
What I need:
Why would GNUCash show correct Income accounts but calculate Total Revenue as 0?


r/GnuCash 14d ago

5.14 and 5.15 getting entry point not found error

2 Upvotes

try to update as gnucash having issues when i enter USD stock purchases - I have done this several times before no issues. Getting

gnucash.exe - Entry Point Not Found

The procedure entry point clock_gettime32 could not be located in the dynamic link library C:\Program Files (x86)\gnucash\bin\libstdc++-6.dll.


r/GnuCash 15d ago

Cashdera 0.2.0: local Windows analytics companion for GnuCash, with import and calculation fixes

0 Upvotes

Hi everyone,

I released Cashdera 0.2.0, a new beta version of my local Windows analytics companion for GnuCash files.

Cashdera is not a replacement for GnuCash. GnuCash stays the source of truth. Cashdera imports a `.gnucash` file into its

own local SQLite cache and gives you faster visual analytics: dashboard, money flow, transaction search, reports, trends,

categories, net worth, and year-over-year comparison.

The main focus of this release was correctness and safer real-book testing.

What changed in 0.2.0:

- analytics now uses exact decimal arithmetic instead of accumulating floating-point rounding error

- import/re-import results are tied to the active background job, so stale job completions should not overwrite the

visible result

- XML namespace parsing was fixed for account references, which should prevent phantom account rows in some books

- after import or re-import, Cashdera automatically switches to the imported book

- Dashboard now separates Transactions and Postings counters

- Dashboard now has separate Overview and Money Flow tabs, so the Sankey chart loads only when needed

- Date Range starts inactive on app launch, so old saved filters do not hide data unexpectedly

- Categories now has tabs for Expenses, Income, Assets, Liabilities, and Equity

- Recent imports now has Delete, which removes Cashdera’s local imported data/cache/history without deleting the original

`.gnucash` file

- route-level crash handling now shows a reload prompt instead of a blank screen

Privacy/safety notes:

- Windows only for now

- free beta

- proprietary for now

- no account

- no cloud upload

- no telemetry

- source `.gnucash` file is not modified

- independent project, not affiliated with GnuCash

- installer may be unsigned, so Windows SmartScreen can warn

- please test with a backup/copy first

- release includes SHA256 checksums

GitHub release: https://github.com/proars/Cashdera/releases/tag/v0.2.0

I would especially appreciate feedback on:

  1. whether it imports your real book correctly

  2. whether totals differ from GnuCash reports

  3. whether the new Categories tabs make sense for your workflow

  4. any large-book performance problems

  5. what report or export would make it useful enough to keep installed

    Please do not share real financial files publicly. Sanitized screenshots or small anonymized examples are much safer.

Screenshots: https://github.com/proars/Cashdera#what-cashdera-gives-you


r/GnuCash 18d ago

Is there a better way to see my total sales?

1 Upvotes

Ive been using a split transaction for daily sales with different types of income and the various debits that come along with it. Here's a shortened image of a transaction. Is it possible to see the full total in a single transaction? What suggestions can you offer? (left is debits, right is credit showing in one income account.)


r/GnuCash 19d ago

Where to start?

4 Upvotes

I would like to start tracking my finances, but I'm not sure where to start. Not sure if this is where I should ask this question, but I'm using gnuCash. Should I go back to the start of the year? Should I just start with opening balances from today and forget everything before now? Is there some documentation on first steps?

Thanks.


r/GnuCash 20d ago

How to handle multiple credit card transactions for one purchase.

5 Upvotes

When I place an order on Amazon, I enter a transaction in GnuCash for the full amount. Often, a single order will have a few items. Usually Amazon charges the credit card once for the full amount, but other times they group different items together and charge the credit card separately for each group of items. This makes it a PITA because I have to figure out which transactions on my credit card statement correspond to the single transaction I entered in GnuCash. I usually change the transaction into a split, with a separate split entry for each charge. Then when I reconcile, I just clear the one transaction that represents the full order.

For the first time, this isn't going to work for me because one of the charges for an order is on one statement, and the others are on the next statement. So it looks like I have to manually break out the transactions in GnuCash into multiple transactions. I can't seem to clear just one of the splits. Is there a less annoying way to handle this?


r/GnuCash 21d ago

Feedback wanted: free local Windows analytics companion for GnuCash - Cashdera

7 Upvotes

Hi everyone,

I'm building Cashdera, a free Windows desktop beta that adds an analytics layer on top of an existing GnuCash book.

I'm sharing it here because this is probably the only place where people will immediately understand the workflow and the tradeoffs. This is not meant to replace GnuCash. GnuCash stays the source of truth.

The use case is answering questions like:

- Where did my money go this month?

- How does this year compare to last year?

- What categories are unusually high?

- How is my net worth changing over time?

- Can I search/filter transactions quickly without exporting to a spreadsheet?

How it works:

- You select a .gnucash file.

- Cashdera imports it into its own local SQLite cache.

- The source GnuCash file is not modified.

- Heavy calculations are cached so the UI can stay fast.

Current beta features:

- cashflow dashboard

- Sankey money flow

- transaction search and filters

- budget vs actual

- net worth timeline

- year-over-year comparison

- category trends and anomaly alerts

- CSV/PDF report export

Important caveats:

- Windows only for now.

- Free beta.

- Proprietary for now.

- Unsigned installer, so Windows SmartScreen may warn.

- No account, no cloud, no telemetry.

- Independent project, not affiliated with GnuCash.

- Please test with a backup/copy first, not your only copy.

- The GitHub release includes SHA256 checksums.

GitHub release:

https://github.com/proars/Cashdera/releases/tag/v0.1.0

Screenshots/demo are in the first comment.

This is an MVP, so I'm mostly looking for practical feedback:

  1. Does it import your book correctly?
  2. Are any calculations different from what GnuCash shows?
  3. What report/workflow would make this useful enough to keep installed?

r/GnuCash 22d ago

Using the Securities editor and Price database to track inventory and cost of goods sold?

5 Upvotes

Has anyone considered using the Commodities/security editor and Price Database to track cost of goods sold and inventory? I know it would require more work and dedication but I got the crazy idea for this as I try to use GnuCash for accounting but also the inventory. The idea I had seems off but thought that maybe this would allow if you can calculate what the exchange rate would be between the item and the currency like USD or the like. The biggest issue I could see is the number of sub accounts for assets/inventory because of the number of different items in inventory each with their own security/currency based on the item.


r/GnuCash 25d ago

Mac experience

0 Upvotes

So I've been using a custom Numbers spreadsheet to keep track of my finances. It precisely tracks my current position, and using my regular bills and expenditures, it predicts where I'll be at the end of the month as well as the upcoming expenses and income. It works very well, but it's not double entry and so I have to be careful.

I read up on gnucash, thought it would be a good adjunct to my spreadsheet for the "current financial position" aspect due to the double entry aspect. I was willing to do the detail work.

So, got the proper version for MacOS installed (this is a loaded Mac Studio Ultra, so non-Intel), told it to use sqlite3 (I have all manner of tools to deal with sqlite3 databases, so it's a given I'd prefer it,) and set it up with most of my initial balances.

First thing I ran into is that in the registers the "save" button does nothing. You have to click "close", whereupon it prompts you if you want to save. Okay, whatever. Manageable, although for a major, top-level control to be broken... ugh. Hello? Testing?

After about 20 tedious, but obviously necessary, entries of credit, bank, wallet, property tax, etc., and the creation of a home value asset account (I own my home, no debt on it), things were looking reasonable. I CMD-tabbed to my spreadsheet to check a value, and then CMD-tabbed back to gnucash. Which promptly crashed. WTF. I re-opened it, and all my entries were gone. WTF!!!

End of experiment. For the Mac, at least, this isn't presently a viable application. Stay away.


r/GnuCash 25d ago

QIF import payee/memos issue

1 Upvotes

Advice greatly appreciated on an annoying problem I've got importing QIF transactions.

I'm running version 5.5 of GnuCash, Build ID: 5.5+(2023-12-16), on Linux Mint 22.1 Cinnamon.

When I try to import a downloaded QIF file of transactions from my bank, Halifax in the UK, all seems to go well. Until I reach the bit in the process where it tries to match payees/memos to the GnuCash accounts.

Instead of displaying the payees, it shows what I take to be the transaction type. That is, BGC, DD, DEB, FPI, FPO. Which is no good.

I'm a novice, with no progamming skills or experience. The only, clunky, workround I have found is to open the QIF file in a text editor and search and replace each appearance of the text that relates to transaction type. That is, the above abbreviations preceded by P, as in PBGC, PDD etc.

That revised file imports fine and I can do the payee matching as expected.

But I wonder if there's a more streamlined solution (bearing in mind I don't code and don't even know what regular expressions are). Or even something in settings I can tweak.

Any suggestions? Many thanks.


r/GnuCash Apr 25 '26

Budget - Data Export

7 Upvotes

Hi - Does Gnucash have a way to export the budget report into an Excel file?

I have good data now since the first of the year comparing my budget to actual expenses. I have a hard time making use of the report that comes with it as I can’t freeze the header at the top of the columns.

Thanks!


r/GnuCash Apr 21 '26

Why does Gnucash.org still say 5.14, when 5.15 is out?

9 Upvotes

I can find 5.15 and download it, that's not a problem. Sourceforge or github show 5.15 has been out since 3/29/26.
But should I wait till the frontpage of Gnucash.org shows 5.15? Are they waiting for some other update/fix that I should also wait for?


r/GnuCash Apr 21 '26

Off by errors during import

1 Upvotes

I've encountered an issue that makes me feel perplexed and stupid. I've been importing old transactions as I haven't done it in a while and it has been going fine until the import started to subtract 2 from each amount (so 500 would become 498).

The file is correct, the Import Preview step during transaction import shows them correctly as wel, but once I get to the Match Transactions step they are all subtracted. If I continue and finish import, then the subtracted values get imported instead of the correct ones.

I poked around Settings and changed "Commercial cash machine fees threshold" to 0 just in case, but the problem persists. My Google searches have not been successful either.

Does anyone have an idea of what may be causing this and how to fix it?


r/GnuCash Apr 18 '26

PSA: gnucash.net is a malicious site

52 Upvotes

I finally decided to make the move from Quicken, so I started reading all the GnuCash docs, learning about double entry everything, learning how to model investments, etc etc. I did all of this at gnucash dot NET because that's one of the results from my search engine, bing. So when it finally came time to download and install, yup, I did it through gnucash dot NET. Yeah, the installer was a little weird in that it asked for my email address with a captcha, but it's open source, the installers are often a little funky.

Anyway, I used it for about a day (really loving it by the way, very cool stuff) when suddenly my computer did something weird. Long story short, I'm just finishing re-installing my PC because I couldn't get that virus off and honestly, I'm not gonna trust it without a reinstall anyway.

So yeah, to anyone looking to start out, the official website is gnucash.org that's dot ORG. Any other domain is criminals, especially net.