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.

learn more… | top users | synonyms

1
vote
0answers
36 views

Get GnuCash to use the Opening Balances account for new accounts

I’m still new to GnuCash, and as such I’m setting up all my accounts. When I first created the file, I didn’t add all my accounts because I wanted to set up only a few at a time. The accounts I did ...
1
vote
1answer
59 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 ...
1
vote
1answer
55 views

Representing a personal loan with double entry

I have received a family loan (no interest or penalties, just a friendly loan) from my parents which is deposited into my savings account for my bank. I'm having issues understanding how I should ...
1
vote
1answer
81 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 ...
0
votes
1answer
68 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 ...
1
vote
2answers
102 views

How to record (accepting and later returning) other peoples' money? What's the correct terminology for that? // GnuCash

How to record (accepting and later returning) other peoples' money in GnuCash? I assume it would not be recorded as income / expense, respectively. Liabilities also seems unlikely. Equities? ...
3
votes
1answer
52 views

Recurring non-scheduled transactions in GnuCash

Does GnuCash have a similar mechanism to MYOB where a transaction can be made into a template for posting when needed? I can see a transaction can be made into a template for automated scheduled ...
2
votes
0answers
92 views

How should I record invoices in foreign currency in GNUCash?

I'm a Canadian living in Canada and I've recently started a new contract with a client in the US. My previous contract specified payment in CAD while my new contract is in USD. I invoice once a ...
1
vote
4answers
243 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 ...
1
vote
1answer
62 views

Dealing with temporary accounts

I use Gnucash for managing my finances. When I receive a gift card, I assume that it should be it's own account as one of my Current Assets. However, once that gift card is fully spent or expired, ...
2
votes
2answers
197 views

In double-entry book keeping, is income always negative?

I've begun trying to learn some money managing techniques, but when fiddling with gnucash I've found that in double-entry accounting, where all money has to come from somewhere, the income accounts ...
8
votes
2answers
1k views

Double-entry accounting: how to keep track of mortgage installments as expenses?

Context: I am new to double-entry accounting, I use GnuCash for my personal family bookkeeping. At the moment, the main goal for me is to keep track of incomes/expenses of our family over time. For ...
2
votes
2answers
95 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 ...
1
vote
1answer
120 views

Splitting already paid bills with housemate

I live with a house mate, and we split our grocery expenses 50/50 between us. Everything is done in cash. I use GnuCash to manage my finances, and I'm not sure how such a situation can be recorded: ...
0
votes
2answers
300 views

Accounting for paying bills for (and being reimbursed by) another person

I an currently using Gnucash to manage my expenses. I am new to double-entry accounting and find many aspects of it to be confusing. Here's a situation that currently happens monthly. I'd like to know ...
0
votes
1answer
78 views

Which account type to use for claimable expense I pay upfront for my employer?

I am using GNUCash for personal finance. Sometimes I pay expenses upfront for my employer with cash or credit card. My employer will pay me back later with cash or cheque. I am thinking of using ...
2
votes
1answer
66 views

How to properly name expense accounts (fees and fines, resp.) with public bodies in the context of personal (non-corporate) bookkeeping? [closed]

How to properly name expense accounts (fees and fines, resp.) with public bodies in the context of personal (non-corporate) bookkeeping? Of course I can just make up a random names, but if standard ...
1
vote
1answer
91 views

How to edit/unpost a posted bill in GnuCash 2.6.1

I created a vendor bill and posted it. After posting it I realized I made a mistake in the amount entered in the bill. The GnuCash Help Manual states on page 79: Before you can edit a posted ...
3
votes
1answer
64 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: ...
1
vote
1answer
92 views

How can I easily show difference between Current Assets and Current Liabilities in Gnucash?

So I have a subaccount of Liabilities named "Current Liabilities" and I'd like to have an easy access to the value of [Current Assets - Current Liabilities] (kind of my personal "Working Capital"). I ...
0
votes
1answer
100 views

Currency Settings

I changed the currency in GnuCash settings from USD to SAR. Although my computer's regional settings are all set to English, GnuCash is displaying me arabic shorthand for SAR (رس). How to change it ...
3
votes
4answers
315 views

GnuCash and version control

I'm starting to organize my accounts more and gnucash seems like a good program to use. If possible, I would like to use version control for my repository (with git, for example) so that I have ...
1
vote
1answer
328 views

Simple income and expense report in gnucash

I do not understand nor do I enjoy accounting. I have a small LLC, and I have a QFX file from my bank that encompasses all transactions from 2013. I would like to import this, manually categorize ...
0
votes
0answers
160 views

How to account for Unrealized Gains in a Trial Balance?

Using GnuCash, When I run a Trial Balance on my accounts, my Debits exceed my Credits by 875.00 wich is the same amount of my Unrealized Gains on the Balance Sheet. How do I reconcile this in my ...
0
votes
1answer
373 views

How can I debit money to Accounts Receivable in Gnucash without raising an invoice?

I have some income from Amazon Associates that is paid to me automatically every few months. I don't raise an invoice and Amazon doesn't create one for me. Amazon does specify a date when the payment ...
1
vote
1answer
165 views

Track expense memos and payees in GnuCash?

I'm using GnuCash to track a simple budget, importing QIF files. Most entries in the QIF file have both a payee and a memo, however GnuCash seems to ignore the memo if the payee is specified. This ...
3
votes
1answer
278 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 ...
1
vote
1answer
666 views

Salary account in gnucash: charge vs. income // example transactions

It might not be the usual thing to have on opening balance in a "Salary" account, but if one did, this is what I tried in gnucash: description: payday again :-) transfer: Equity:Opening Balances ...
8
votes
1answer
221 views

How to record the finding of 10 dollars lying on the street and their subsequent placement into one's wallet (in gnucash)?

Within gnucash: within the Cash in Wallet account: description: found some money in the street transfer: Imbalance-USD or create a new arbitrary one-off account called something like "Penny Lane" ...
4
votes
2answers
2k views

In double entry accounting, how does income become equity?

Using GNUCash, help, putting it all together, I'm accounting for a lottery income transaction. I was able to get the example shown with 2 transactions. 1. Dr. Savings 750,000 Cr. ...
1
vote
1answer
794 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
1answer
225 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: ...
3
votes
1answer
354 views

Using GnuCash for accurate cost basis calculation for foreign investments (CAD primary currency)

I'm looking to use GnuCash for investment tracking and while I evaluate the software, I am specifically interested in how to get it to properly calculate the ACB of foreign investments in CAD. For ...
4
votes
2answers
911 views

In double entry accounting, how do I enter a loan?

I have taken an accounting course several years ago, but I'm a little rusty. I'm using GnuCash, double entry accounting software. I have a loan from a friend, so no interest. I have paid about half ...
1
vote
3answers
596 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, ...
3
votes
1answer
733 views

How can I show more detail in GnuCash Reports?

I recently started using GnuCash as a tool for tracking my expenses. It has lovely built in reports on expense, but it seems to limit the categories/accounts displayed to a fairly low number (I think ...
5
votes
1answer
446 views

Gnucash category structure for funds distributed across multiple bank accounts

In Gnucash, what is the best way to structure category accounts which will hold funds distributed across several bank accounts? In Canada we have Tax Free Savings accounts which return more interest ...
4
votes
2answers
328 views

Duplicating transaction splits in gnucash?

I've imported 4 years of banking history into gnucash. I have regular transactions which I'd like to split into categories (which I understand are "accounts" in gnucash terms). For example: $400 - ...
5
votes
2answers
917 views

Good way to record currency conversion transactions in personal accounting software?

I have deep personal financial connections to two countries, with different currencies. (They happen to be Canada/CAD and USA/USD, but I don't think that's material.) I have multiple bank and ...
3
votes
1answer
212 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 ...
6
votes
2answers
373 views

How should I record the changing value of an investment in accounting software?

I have the following (simplistic) structure set up in GnuCash, but this should apply to other software too: Assets Bank account Pension Income Salary Interest Every month, my salary is ...
6
votes
1answer
234 views

Gnucash extension to generate interest entries

I often find myself manually entering interest (and according tax) entries for savings accounts in gnucash. Is there a plugin or extension available where I can enter the initial value, the interval ...
6
votes
1answer
133 views

Accounting for payment into wrong currency account

I deal with clients in several countries and have two bank accounts in two currencies. Recently, I sent out an invoice with the wrong bank account number, so a client invoiced in SGD made a payment ...
2
votes
1answer
697 views

How does GNUCash calculate “profits”

At the bottom is a summary bar, which shows "Net Assets" and "profits". I'm slightly baffled at what GNUCash thinks profits are, since it seems to be different than "net worth".
5
votes
2answers
277 views

Is it possible to add your own currencies or other “countable entities” in GnuCash?

I'm trying to track the income and expenses of an essence that is not listed as any pre-defined GnuCash currency (say, bubble gum stickers, number of calories or air temperature). Is it possible to ...
9
votes
1answer
196 views

Is it possible to track meter readings in GnuCash?

I'd like to keep the record of, for example, water and electricity consummation. Is it possible to properly implement a pseudo-account in GnuCash to store the meters' readings? Even more, having the ...
3
votes
1answer
150 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 ...
7
votes
1answer
2k views

Starting with GnuCash. How to eliminate automatic entries ending up in the “unbalanced” account?

I just started using GnuCash and there is something I do not quite get how to get rid of (and whether I should try to get rid of). When I start importing transactions, I have expenses, income, etc. ...
9
votes
3answers
2k views

improve gnucash OFX transaction matching

I wrote a script that cleans up OFX transaction files downloaded from banks so that the name and memo fields are more readable once imported into gnucash. This works great, I now get very clean ...
7
votes
2answers
918 views

What's the difference between 'cleared' and 'reconciled' in my financial accounting software?

Been using GNUCash for the past four years, and I'm slowly learning the more advanced features over time. Until now I've never needed to bother with future dated transactions, but recent large ...