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
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
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
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
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 ...
3
votes
1answer
989 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
243 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
1answer
110 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
0answers
140 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
89 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
157 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
3answers
3k views

What is the Equity account for in GnuCash?

What is the purpose of Equity account in GnuCash? For example, I have income through Salary account $500, after I have expense by buying book for $5 (so in Expense:Books account is entry for $5). But ...
2
votes
2answers
115 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
73 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
546 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
1k 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
170 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
212 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
237 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
4answers
120 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
623 views

How to link duplicated transactions between two accounts in GnuCash

I imported (Actions > Online Actions > Get Transactions...) transactions of my two of my accounts (bank account and credit card). Among these transactions is one that transfers money from the bank ...
2
votes
1answer
99 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
404 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
346 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
3k 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
232 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
930 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
151 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
286 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
285 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
394 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
665 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
175 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.
2
votes
2answers
476 views

Book capital losses in gnucash

I have an asset in gnucash, and its value changes over time. I followed these instructions and know how to record the gains, but it's unclear to me how I record the losses. The help page describes ...
2
votes
2answers
832 views

Budget Report with Cumulative amount in Gnucash

I want to see during a year if I am good with my household budget. I have made a monthly budget for all my expenses and income. Thus I would like to see for example in June what the current amount ...
2
votes
1answer
959 views

How To Assign Payments Received Properly In GnuCash?

What is the "proper" way to make sure that a payment I receive for an invoice is "assigned" to that particular invoice? (I feel like many payments I have received don't get assigned to an invoice and ...
2
votes
1answer
592 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
341 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 ...
2
votes
1answer
197 views

Newest transactions added on top, not bottom, of accounts in GnuCash?

In GnuCash, with ascending date the transactions are listed from top to bottom. Is there a way to have the transactions listed with ascending date from bottom to top? I.e. I want the newest ...
2
votes
1answer
727 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 ...
2
votes
0answers
45 views

Scrolling in Gnucash [closed]

Scrolling in a Gnucash register seems extremely touchy - the slightest touch on my touchpad (I have a MacBook Pro) scrolls a whole screen of transactions. Is there any way to adjust the sensitivity? ...
2
votes
0answers
140 views

Obtaining Figures For Australian GST Business Activity Statement From GNUCash

I have been entering all my financial records into GNUCash, and now I need to find the most efficient way to extract all the needed figures for the BAS. The Income & GST Statement looks like the ...
2
votes
0answers
45 views

Can't issue SEPA transaktions because account doesn't have SEPA information stored

I have Gnucash 3.4-3 and Aqbanking 5.7.8-1 installed on Arch Linux. When I try to issue a SEPA transaktion i get the error message: Your local bank account does not yet have the SEPA account ...
2
votes
0answers
48 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
0answers
293 views

Gnucash budget report not adding subaccounts

I have problems budgetting for accounts that contain subaccounts. Gnucash does not seem to want to add the actual values in the subaccount, to get the correct value for the parentaccount, but in stead ...
2
votes
0answers
73 views

Head of Household and dependent status tracking with GnuCash

I would like to use GnuCash (if possible) to track my status as head of household and my mother's status as a dependent. The rules are in IRS Publication 501 (mostly worksheet 2). My ultimate goal is ...
2
votes
1answer
943 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 ...