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
1answer
293 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
127 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
519 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
461 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
393 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
501 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
887 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
2answers
2k 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
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
104 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
1k 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
252 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
182 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
96 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
167 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
187 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
89 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
2answers
749 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
1answer
2k views

How to record currency exchange in double entry

I decided to make my own double entry accounting program that deals with multicurrency. However, I am facing an issue in dealing with following scenario: I have two bank accounts: From: Opening ...
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
178 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
2answers
47 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
1answer
296 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
250 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
90 views

Splitting a transaction difficulty

I'm using Gnucash to keep track of my personal finances and am new to the program. I've been trying to learn how to split a transaction and it simply isn't working. Here's what I've done so far: I ...
2
votes
1answer
85 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
4answers
157 views

GNUCash how to properly register a “bonus” on a transpit pass/gift card

What is the proper way to record "bonus" money on a card. specifically, when I charge my transit pass for 100, I actually get 150 on the transit pass account. how do I record the extra 50?
2
votes
1answer
105 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
81 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
419 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
504 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
359 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
646 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
2k 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
242 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
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,...
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 ...
2
votes
1answer
66 views

How to classify eBay sales and PayPal income on GNUcash properly?

I tried to figure this out but can't seem to do it. Here's my thinking: income:eBay - €10 from eBay (true) Then this money goes to: bank:PayPal €9.75 expenses:PayPal fees €0.25 Then the PayPal ...
2
votes
1answer
176 views

Manually updating portfolio value in GnuCash

I have left Quicken version 8 to start using GnuCash. One of Quicken's great assets is the capacity to record and/or display stock prices for any historical date, provided the history has been ...
2
votes
1answer
410 views

GnuCash - Show Total (Custom Currency) in Accounts view

In the Accounts view/tab, when selecting the columns to be visualized, the column Total is showing the total for each account in the respective currency (as intended). I want to see the totals in EUR ...
2
votes
1answer
353 views

GnuCash Loan and Credit Card showing as debits

Setup GnuCash 2.6.12 Ubuntu 16 $10,000 loan from external party (Brandon) In the official GnuCash documentation, it states that: GnuCash treats account types Credit Card and Liability the same. ...
2
votes
1answer
451 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 ...
2
votes
1answer
704 views

GnuCash Conversion from Quicken

I successfully downloaded GnuCash and linked it with my Quicken data files. But now all my account information is scrambled--bank balances up or down by an order of magnitude, securities sold long ...
2
votes
1answer
244 views

How do I pick the location where Gnucash backs up to?

I would like to back up Gnucash to a external hard drive. Latest Gnucash version and latest Mac OS 10.12.6.