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
878 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
238 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
1answer
464 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
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
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
0answers
65 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
132 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
144 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
102 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
496 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
42 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
998 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 ...
2
votes
1answer
1k 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
179 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
143 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
232 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
107 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
495 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
96 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
386 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
479 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 ...
2
votes
1answer
341 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
2answers
228 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
884 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
136 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
242 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
251 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
361 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
639 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
164 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
418 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
765 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
888 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
577 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
324 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
176 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
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
1answer
715 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
34 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
100 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
43 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
43 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
277 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
71 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
892 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 ...
1
vote
4answers
227 views

How do I record my spouse's payment in shared credit card account?

I've created a credit card liability account. My spouse shares my credit card and makes several purchases on it as well. Each of us makes a payment directly against that account at the end of the ...
1
vote
1answer
234 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 ...