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
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: ...
1
vote
1answer
345 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
884 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 ...
7
votes
4answers
1k 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 ...
3
votes
2answers
1k 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 ...
1
vote
2answers
6k 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 ...
2
votes
1answer
2k 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 ...
2
votes
2answers
942 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
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 ...
1
vote
1answer
4k 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 ...
11
votes
1answer
581 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" or ...
17
votes
3answers
12k 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. Income:...
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
1k 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
2answers
1k 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 ...
6
votes
2answers
4k 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 ...
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, ...
7
votes
1answer
4k 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 ...
8
votes
1answer
1k 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 ...
6
votes
2answers
1k 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 - ...
12
votes
2answers
3k 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
417 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 ...
9
votes
2answers
1k 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 split ...
7
votes
1answer
358 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 ...
7
votes
1answer
706 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 ...
7
votes
1answer
3k 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".
9
votes
2answers
2k 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 ...
10
votes
1answer
332 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
2answers
460 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 ...
17
votes
2answers
12k 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. ...
18
votes
3answers
5k 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 ...
19
votes
2answers
13k 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 ...
5
votes
4answers
2k views

How do I set up the formulas to properly split monthly loan payments to principal and interest?

This has been a small annoyance for months now: the formulas GNUCash produced via loan repayment wizard don't match up with my lender's amortization tables. The formulas use pmt() functions, like this ...
9
votes
1answer
2k views

Gnucash: Add new column for bookings

Is there a way to add a custom column for accounts in gnucash, so that I can add special information to bookings like: "Who added the entry?" or "What is the date of the bill?" I could input this ...
6
votes
1answer
2k views

GnuCash bookkeeping for account contributions to accounts having annual contribution limits?

I'm using GnuCash, and trying to figure out how to structure a couple of accounts to track contributions to accounts like Roth IRAs and HSAs that have an annual contribution limit that I need to track....
11
votes
2answers
3k views

Setting up general ledger/tax reporting for a Real Estate Rental LLC in GnuCash

I have downloaded the GnuCash accounting software for use with our real-estate rental LLC, in hopes of following more universal accounting practices and determining our individual cash basis, but my ...
4
votes
1answer
468 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?
16
votes
2answers
2k views

What is the best cross-platform GPL personal finance tool available?

If I want desktop, web and mobile (preferably Android) access to all my accounts and assets, in a personal finance tool, what would you recommend I look at? Until Wesabe cancelled their web dashboard ...
7
votes
2answers
847 views

What is a good open source Windows finance software

I have played around with GnuCash a little but it doesn't quite meet up to what I am looking for. I currently run QuickBooks and use class tracking to keep a fine line of separation between my ...
20
votes
4answers
21k views

What headaches will I have switching from Quicken to GnuCash?

I'm interested in switching to an open source checkbook program. I currently use Quicken and I'm interested in switching to GnuCash but I have usability concerns. Does GnuCash have all the features ...

1 2 3 4
5