Questions tagged [gnucash]

For questions related to the GnuCash personal and small-business financial-accounting software freely licensed under the GNU GPL. As this is a personal finance site, questions about usage of the software are preferred over technology-related questions.

Filter by
Sorted by
Tagged with
4
votes
3answers
6k views

How to resolve imbalances and orphan transactions in Gnucash?

I am a new Gcash user. I Installed Gcash and imported couple statements from my bank. It is all good except that I now have huge imbalances. And I do not know how to handle this. I looked around the ...
4
votes
1answer
3k views

GnuCash and ledger/hledger [closed]

I am using GnuCash 2.6.7 under Mac OS X 10.10.4 to do my personal finance. I have a fairly large account structure by now with many expense accounts to track different categories of spending. I would ...
4
votes
2answers
356 views

How to make wrong amount in gnucash account in line with real amount?

My checking account shows a value that is higher then it actually is according to my bank statement. As far as I know I've only added transactions that have already been processed, so it should be the ...
4
votes
2answers
390 views

Double entry for mortgage

Q. What entries should be made for mortgage and interest only repayments? For info I use GnuCash. Situation: I have an interest (repayment) only mortgage of, say, £50,000. They added their fees to ...
4
votes
2answers
3k views

Processing PayPal transactions Via GNUCash

I am taking the time to set myself up to record finances in GNUCash, and I have slowly been refining my recording processes. I am curently twiddling my thumbs about how to treat "Middleman" ...
4
votes
2answers
657 views

GNUCash: How to count up equity?

I'm new to getting my finances in order, and I've decided to use GNUCash to track my spending and general financial health. I'm reading the manual and trying to take control! My trouble and ...
4
votes
1answer
501 views

gnucash - Record several years data

Currently I am using GnuCash to record my personal expenses. I am using it since the last year, so in my master book I have records belonging to the years 2013 and 2014. Is that the correct way to ...
4
votes
2answers
1k views

How separate individual expenses from family expenses in Gnucash?

After discussing the finances with my spouse I realized that there is no way to easily determine whether an item was purchased as part of our individual accounts, or our combined family account. ...
4
votes
5answers
4k views

In double entry accounting, as an employee, how do I enter expenses?

I'm new to accounting and just started using GnuCash for my personal finances. Question As an employee (not a company), how would you enter the following transaction into GnuCash? Situation I make ...
4
votes
1answer
674 views

Unable to retrieve quotes in the modern GnuCash with Alpha Vantage

I have a problem getting currency and symbol quotes in GnuCash. When I open Tools - Price Database and click Get Quotes, in several seconds I see a dialog with the following text: Unable to retrieve ...
4
votes
2answers
496 views

gnuCash: Selling a car

I bought an old car two years ago for 4000$. Now I am selling it for 2000$. Meanwhile I had much repairs which exceeded all the prices. Determining the value of such an old car is hard. Once upon a ...
4
votes
1answer
459 views

Gnucash: Keyboard shortcut to move to blank transaction?

When entering transactions in Gnucash, there is a toolbar icon to jump to "Move to the blank transaction at the bottom of the register". What is the equivalent keyboard shortcut to do that?
4
votes
2answers
683 views

GnuCash recreating Quicken report

I am a quicken user hoping to transfer to GnuCash. I like GnuCash a lot, but am having trouble with creating some specific reports that (IMO) are easy to create in Quicken. Specifically, I have ...
4
votes
1answer
4k views

Importing .csv into GnuCash

Exported my Expenses Sub Account from GnuCash as .csv file and got the undermentioned 16 column headings. Date Account Name Number Description Notes Memo Category Type Action Reconcile To With Sym ...
4
votes
1answer
663 views

How can I export transactions from GnuCash including references to associated files

I can add files to transactions using menu Transaction > associate file with transaction to assign files. I want to export the transactions in a way so that this file reference it included in ...
4
votes
1answer
966 views

How do I track an interest free loan I made in GNUCash? How do I track payments against that loan?

I use GnuCash for my personal accounting since 2008. As I am not a native English speaker, I struggle with the understanding of some GnuCash manual terms and explanations that I do not use in my daily ...
4
votes
2answers
398 views

How to record HSA-reimbursable medical transaction into gnucash?

I'm using gnucash to record my finances (but it should apply to any double entry accounting system). I wonder how should I record transactions for medical expenses which I can reimburse from HSA (and ...
4
votes
1answer
110 views

GnuCash “Currency Sync Point” (Fix currency in a wallet at a given date)

Instead of starting a clean account with an opening balance from equity, I've started an account and know the current amount and working on recovering most of the transactions from the last 5 months: ...
4
votes
2answers
981 views

How to record existing double entries in GnuCash

For example if I transfer $ 5,000.00 from my checking to savings a/c on 6/1 these two entries appear in my bank a/c statement - Checking: 6/1 -5,000.00 Transfer to checking a/c YYY Saving: ...
4
votes
3answers
2k views

Show liability payments with expenses?

In GnuCash Liabilities are separate from expenses, which makes sense. However, this makes it difficult to get a useful budget report or expenditure report since it does not include my largest outgo, ...
4
votes
3answers
315 views

How to set up saving for items in GNUCash: Asset or Expense

Let's say I'm saving for a car and I would like to save X amount on a month to month basis, where would I generally put this?
4
votes
1answer
771 views

Handling multiple currencies in GnuCash

I started using GnuCash when I used in Germany and hence I have a whole EUR structure in my database (Aktiva, Anfangszustand, Aufwendungen, Ertraege, Fremdkapital). Later, I moved to the US. I ...
4
votes
1answer
1k views

Import stock transactions from Excel to GnuCash

I'm trying to automatize the process of import financial data from my stock broker to Gnucash. I'm looking for a way of export the Excel data from my broker to QIF of other suitable format to be ...
3
votes
3answers
726 views

Accounting equation: does income really decrease equity?

I am new to using double-entry bookkeeping for personal finances. GnuCash uses a variant of the accounting equation that has five variables, and which seems to be known colloquially as an "expanded" ...
3
votes
1answer
203 views

Gnucash fee option

My problem is that I can't handle translations with fees using gnucash. For example, I have an account that represents my bank account. I'd like to withdrawal $100 and my bank will also charge me ...
3
votes
2answers
304 views

Gnucash: How to find transactions of a specific amount?

I've got a Gnucash credit card account in which I'd like to find all transactions of a specific amount. The Find window doesn't have the Charge Amount field in it, and I don't see any relevant ...
3
votes
1answer
181 views

GnuCash: expense tracking/amounts left under limits

So I've decided I want to try and rein in my spending a bit, and keep my money a little more under control, and while I know there are more simple expense tracking programs, I'm not one to use a ...
3
votes
1answer
543 views

Setup Rental Security Deposit account in GnuCash

I'm new to GNUCash and creating a new GNUCash file to track my rental. I have a security deposit account with my bank, and am trying to make sure I get this all setup correctly. In quicken, I had an ...
3
votes
1answer
2k views

Making good use of the (optional) Num column in gnucash? “name-of-counterparty” column

In previous humble attempts to learning-the-ropes of household accounting (in conventional spreadsheet software) I used to have a column to hold the name of the counter-party, e.g. the supermarket ...
3
votes
1answer
410 views

Getting Started with personal accounting software

My wife and I have been keeping a check book by hand since 2004 when we where married. We would like to start using a piece of accounting software (GNUCash) to track our finances instead. How far ...
3
votes
1answer
222 views

gnucash: search transaction across all accounts

When I search a transaction I have first to choose an account, then by Edit - Find... I can search this account by several criteria. If there is no match I have to choose another account and repeat ...
3
votes
2answers
742 views

How would I set up an account in GNUCash to track savings and coupons

My goal would be to track the so-called "savings" I get from the grocery store or pharmacy when items are bought on sale. (That way I can really save by putting that money aside) But I'm not sure how ...
3
votes
2answers
296 views

How do I prevent the use of duplicate invoice numbers in Gnucash?

I'm not an accountant or bookkeeper, but I have been using Gnucash to enter and manage my invoices. I had an instance where I used B192116 for an invoice number and the customer paid this invoice. A ...
3
votes
1answer
102 views

How do I properly account for interest charged on a loan in GnuCash?

I've just started accounting and entering initial balances for my personal finances with GNUcash and I'm curious about the proper way to account for interest charged on student loans and credit cards. ...
3
votes
1answer
246 views

Gnucash brokerage account with multiple stocks

GNUCash setup is driving me nuts. Most accounting software tools allow you to create a brokerage account that holds multiple securities. The account ledger can have transactions for all the ...
3
votes
1answer
96 views

Find cost for specific investment over last year in GnuCash

I have a mutual fund account containing purchases over several years. Each year there are many individual purchases. The "Balance" column is useful for telling me the total number of shares purchased ...
3
votes
1answer
127 views

Full amount spent on Liabilites GNU cash

I would like to have a total of just the charges on a liability such as a VISA card. Take out the payment data.
3
votes
2answers
774 views

Why doesn't GnuCash auto-reconcile non-bank accounts?

I use GnuCash for the sole purpose of keeping track of my personal finance. When I do my monthly reconciliation on my checking account, savings account, and credit card account and everything is all ...
3
votes
1answer
479 views

GnuCash during holiday: expenses in foreign currency

I am using GnuCash for keeping track of my personal finances. My currency is mostly Japanese Yen and I live in Japan. I keep track of every single Yen, every single purchase. Now I am going on ...
3
votes
2answers
2k views

How to track expenses from an account in gnucash?

I can't figure out how to select three assets (cash + two bank accounts) and a bunch of expenses, and get a report on how much has been spent from those accounts on those expenses. Cash Flow won't do,...
3
votes
2answers
314 views

How should I document mandatory furlough in GNUCash?

My union contract requires a certain number of furlough hours be taken over the next year and a half. Furloughs are basically unpaid vacation--I don't show up, and don't get paid. How should I ...
3
votes
1answer
58 views

How do I record a split transaction in a QIF manually?

I am trying to write a QIF file manually so I can learn to convert csv files to QIF myself without a third party app on Linux. I am having difficulty understanding how to record a split transaction. ...
3
votes
1answer
102 views

Can I visually highlight or mark transaction in GnuCash?

I was wondering if it was possible to highlight the last transaction of the month on my credit card account, for instance, so I can easily see where one credit card statement ends and another begins. ...
3
votes
1answer
104 views

How to get visibility into contributions to assets

I'm using double entry with Assets, Expenses, Income, Liabilities, and Equity. To illustrate my question with easy round numbers: Income one month is 10k; 5k goes into an asset like a 401k account (...
3
votes
1answer
796 views

Tracking Stocks in gnucash: Total mount shown in the ledger is wrong

I recently started buying some stocks and track them with gnuCash. I used the gnuCash manual to get started. Basically I have Assets:Broker Account where I transfer money. From this account I buy ...
3
votes
1answer
437 views

How would I account in GnuCash for me and another entity contributing to a joint account?

Me and my wife are starting a joint account, separate from both of our accounts. The intent is for both of us to contribute equally to the account and use it for joint purchases. When I make a ...
3
votes
1answer
3k views

How to improve Gnucash QIF import matchings by adding account to each transaction

I'm trying to suppress the longest part of my QIF import process which is manual matching of each transaction to each account. I have the bayesian matching activated but it performs poorly, matching ...
3
votes
2answers
1k views

How should I record outstanding expenses in GnuCash?

By 'outstanding expenses,' I mean bills that are due but that you cannot, at present, pay. Nor do you know exactly when in the future you would be able to pay. Here's what I've experimented with: I ...
3
votes
3answers
1k views

Convention for adding ishares (ETFs) into personal accounts

I use GNUcash to manage my personal accounts. Please advise me on how I should enter ETFs, specifically ishares which are Blackrock's brand of ETF, into my personal accounts. The default set of ...
3
votes
1answer
64 views

Gnucash: Checking acct -> Checking acct -> expense account

im new to gnucash but I have most of my accounts working and reconciled now. This one however I can't square in the books: I have gotten a refund on paypal and I transfered the money back to my ...