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
3
votes
2answers
3k 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
1answer
2k 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 bill,...
3
votes
2answers
493 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
273 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
96 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 ...
3
votes
1answer
424 views

Exporting Account Totals in GNUCash

I use GNUCash for personal finance and need to find a way to export the balances of all of my accounts in one CSV or any spreadsheet file. Exporting Account Tree doesn't work, and exporting ...
3
votes
1answer
129 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
1k 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
534 views

Coding Expenses to Vendors Without Entering a Bill in GnuCash? [closed]

In QuickBooks, when using the "Batch Transactions" window to enter transactions, I can allocate the transaction to a vendor without creating a bill. I.e., when I charge an "Office Expense" for copy ...
3
votes
1answer
486 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
403 views

Gnucash: How to add up all charges on a credit card within a period

I have "Liability" account in Gnucash for my credit card. Each expense made using my card is shown there as "Charge", while each payment I made to the credit card account from my checking account is ...
3
votes
1answer
516 views

How do I record monetary advances and money spent thereof in personal accounting?

I have recently (i.e. from the beginning of 2015) started tracking my personal finances with GNUCash, without any previous experience in accounting. While the interface is mostly intuitive (thanks to ...
3
votes
1answer
4k 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
988 views

How can I find out in GnuCash how much I have spent in a given time period?

I started doing double entry bookkeeping with GnuCash to keep track of my personal finances, down to the penny. I think I am familiar with most of the basics of double entry bookkeeping, I took a ...
3
votes
3answers
2k 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
133 views

How do you handle ESPP in gnucash?

How do you enter buying and selling ESPP (Employee Stock Purchase Plan) shares in gnucash? For example, say one purchased 100 SHS of XYZ on 5/1/18, a grant date of 12/31/17, where the acquisition fair ...
3
votes
1answer
493 views

Tracking employee stock option grants in GnuCash

I've been using Gnucash for a while now and I'm starting to feel like an accountant. :) Anyway, I've been interested in trying to map out employee stock option grants for a while to form a more ...
3
votes
1answer
2k views

How to account for digital currencies in a double ledger book

I put my personal finance records in GnuCash and I would like to understand how to best account for digital currency transactions. My book is for tracking EUR transactions. Scenario 1: I hold 1 BTC ...
3
votes
1answer
262 views

GnuCash: Reimbursable expenses paid by credit card

In my business we buy a number of things for client projects with the company credit card. I understand that to have them show up on the client's bill I need to use the Vendor-Bill process. But when I ...
3
votes
2answers
1k 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 ...
3
votes
0answers
91 views

Can I set GnuCash to denominate everything in a security (Bitcoin)?

I have all my personal finances in GnuCash. EUR is now my main currency. The menus allow me to set the main "currency" to, naturally, currencies. I have bitcoin as a security. Can I set my ...
3
votes
0answers
206 views

Accounting for monthly vested stock options as compenstation in GnuCash

I am working for a company that has recently gone public. Now I see a monthly accumulation of options vesting every month. I would like to account for these options as compensation in my accounts. ...
3
votes
0answers
106 views

How do I see how much savings I will have at the end of the budget period with GnuCash?

I have set up a budget in GnuCash for a one year period, and I started out with some money in each of my accounts. How do I find out how much money I will be left with at the end of the budget period? ...
3
votes
1answer
1k views

Gnucash: How to track similar expenses in two currencies appropriately?

Suppose that someone spends most of their life in one country with currency X, and a few years in another country where they have currency Y. Let's suppose also that the person earns a similar income ...
3
votes
1answer
180 views

Can a vendor send an invoice file that can become my bill?

Both I, and a vendor I do business with, use GnuCash. It would save me a lot of labor if my vendor could send me an invoice file made by his GnuCash installation that can be read by my GnuCash ...
2
votes
2answers
214 views

Gnucash - view statements

In Gnucash, I've been starting to use statement reconciliation for my bank & credit card accounts. Is there some way to see the statements I've already reconciled? Ideally I'd be able to see all ...
2
votes
2answers
95 views

Gnucash: Default reconcile date to today?

When I begin reconciling an account in GnuCash, the statement date field is populated with a value that seems to be random. Is there a way to make it default to the current date?
2
votes
1answer
716 views

How do I unlock my Gnucash file to continue working on my accounts?

My file is Murphy.gnucash. There is a file called Murphy.gnucash.LCK in the same folder. When I open my file in gnucash, it gives me these options: Open Read-Only Create New File Open Anyway Quit ...
2
votes
2answers
837 views

How to only show transactions between a specified date range in GnuCash?

I'm still new to GnuCash so please bear with me: My business has year end 03/31 and I was wondering if I can select a date range so that it shows me transactions within the range? Or am I supposed to ...
2
votes
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
2answers
78 views

How to track money used for shared expenses against a personal loan?

I've recently (3 months ago as of writing this) got into proper double entry bookkeeping for my personal finances. I've been using GnuCash, though this pertains more to double entry practices than ...
2
votes
2answers
188 views

GnuCash how to do laptop purchase payment plan

I bought a laptop for $1000 online and paid by credit card. The payment plan is 10-month payment with 0% interest rate. So it charges $100 to my credit card each month. In this case, how do I do it on ...
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
1answer
125 views

Not tracking cash, paying for others

I am new to GnuCash. I don't want to track cash money. Money withdrawn from the bank account should be considered spent. I have an Expenses:Cash account for this. Now I have the situation that I payed ...
2
votes
1answer
389 views

How to make entries for a cancellation fee & return in GnuCash

I have booked some flight tickets using Debit Card and then later had to cancel them. I received part of the money after cancellation fee is deducted. What is a good way to record this type of ...
2
votes
1answer
258 views

Double entry accounting: as an employee, how do I enter expenses in foreign currency?

I use gnucash. For my company expenses I follow advices from In double entry accounting, as an employee, how do I enter expenses? and I am happy with the results. But I get to travel often to country ...
2
votes
1answer
86 views

Can I open multiple Gnucash account tabs at once?

I have an investment parent account with more than a dozen subaccounts, one for each ticker symbol. When I go to reconcile a statement, I've been opening the subaccounts one at a time - i.e., I open ...
2
votes
3answers
98 views

Setting up and tracking internal funds in a double-entry system for personal finances

I am trying to properly set up some internal funds in a double-entry context for personal finances. For example, I have a Home Improvement fund to which some variable amount of money may be added ...
2
votes
1answer
122 views

How to split joint expenses at regular intervals in double-entry bookkeeping?

I am trying to use GnuCash to keep track of the expenses (such as rent and electricity) in a shared apartment. For historical reasons, I pay for all the bills from my personal checking account. At the ...
2
votes
1answer
111 views

Expense lower due to reimbursement. How to put in administration?

I only recently started to document my financial administration properly. Before, I had an Excel file with all transactions of my bank account (and a separate one for my savings account). Recently I ...
2
votes
1answer
137 views

Do GnuCash Income entries ever stop contributing to the Income Account's total?

I'm building a personal budget in GnuCash and after entering my starting equity, I've added my new paycheck in the Income section of my budget. I've entered it as transferred to my Checking Account ...
2
votes
1answer
91 views

How can I duplicate existing transactions and assign them to a new invoice?

I originally created a set of invoices, each with a set of itemised transactions for work done and duly sent them to my client at the time. Because he's tardy, he neglected to pay the invoices on time ...
2
votes
1answer
425 views

How do I deal with initial transactions from online banking

I've just set up gnucash to pull transactions from one of my credit card accounts. It works and the transactions are imported; however, the account balance listed is wrong. I think this is because it ...
2
votes
1answer
577 views

gnucash share fractions

For tracking shares in GnuCash, the maximum number of decimal places allowed seems to be 8 (100 millionth) but I'm dealing with fractions with 9 decimal places. Any extra decimals after 8 get ...
2
votes
1answer
369 views

GnuCash: Copy & Paste Balance Sheet

I would like to use GnuCash for the limited purpose of inputting an existing balance sheet at a particular point in time (just the totals at year end, NOT any of the activity) in order to enter ...
2
votes
1answer
678 views

Gnucash: how to combine scheduled transactions and online banking data?

I don't know how to combine scheduled transactions and banking data in practice. What I have done already: I am fairly new to accounting, but have read Accounting for Computer Scientists, so I know ...
2
votes
1answer
4k views

List of banks with free OFX service [closed]

I am looking for a list of banks that offer a free OFX (Open Financial Exchange) service. The best list I have been able to find is here: OFX List Some of the banks on this list are documented to ...
2
votes
1answer
3k 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 ...
2
votes
2answers
245 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? Maybe... ...
2
votes
2answers
1k 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 ...