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
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 ...
0
votes
1answer
47 views

report: group account activity by accounting period instead of by month

I'm using GnuCash 2.6.12 and would like to create an annual report for tax reporting purposes. For that, I would like to create a report where transactions are grouped for the whole year, (the ...
2
votes
0answers
82 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 ...
0
votes
1answer
147 views

Gnucash - Report cash flow on a per-asset basis

I'm not sure I'm using the correct terminology but I have a number of "assets" which are sub-accounts of a checking account: Checking account - Designated funds 1 - Designated funds 2 ... What I ...
8
votes
2answers
814 views

How to continue using the online banking feature of GnuCash (AqBanking) with PSD2 in effect?

I'm running GnuCash 2.6.19 (with AqBanking 5.7.8.0) on Ubuntu 18.04.3 LTS. Ever since the European Commission's Revised Directive on Payment Services (PSD2) came into effect online banking with the ...
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:...
1
vote
1answer
52 views

Including benefits in kind within accounts

I'm producing accounts for a local political party using GNU Cash. There are a lot of benefits in kind that we need to account for. Previously I included these on a separate spreadsheet, but would ...
2
votes
2answers
2k 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
1answer
77 views

How do I properly account for interest charged on a loan in GnuCash?

I've just started accounting and entering initial balances for my personal finances with GNUcash and I'm curious about the proper way to account for interest charged on student loans and credit cards. ...
1
vote
0answers
29 views

Capital Gain report with currency conversion of purchase cost

I have setup gnucash in my windows laptop. It does what I want and it does flawlessly. I have one question though. My default currency is AUD. I have investments in shares in indian currency. Using ...
0
votes
2answers
142 views

How do I get Gnucash to automatically assign expenses to accounts?

I'm using Gnucash. I'd like to create "virtual subaccounts" for my debit account to keep track of expenses. E.g: debit account --> groceries Regular "virtual payment" to groceries every month ...
2
votes
1answer
212 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
4answers
90 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?
3
votes
1answer
59 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 ...
0
votes
0answers
30 views

Printable Invoice Configurations

When I create a printable invoice I see the option to save its configuration. I thought at first this was to enable saving what columns, and other features, are to be printed so that this need not be ...
3
votes
1answer
141 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 ...
0
votes
0answers
70 views

Modeling joint expenses in gnucash

I want to set up gnucash to register the house expenses and be able to see how much money I should return to my wife or her to me every month. The situation is as follow: We share common expenses ...
3
votes
0answers
42 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 ...
2
votes
1answer
118 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 ...
4
votes
2answers
1k views

How to delete multiple transaction at once in GnuCash?

How can I delete multiple transactions in a batch in GnuCash? My specific use-case is that I am treating each year as a standalone gnucash file. I start with a copy of the previous year and import ...
16
votes
2answers
11k 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. ...
1
vote
1answer
152 views

GnuCash to track expenses when refunds occur

I've started using GnuCash to keep track of my expenses so that I have an idea of how much I spend each month for food, clothing, etc. My main goal is to be able to see if I went out of budget one ...
0
votes
0answers
56 views

Gnucash accounts not opening!

I've used Gnucash for about a year now - Macintosh Version 3.3 Build 3.3+ (2018-09-29). Every month I open it and update the books, and output two reports. But today when opening, it gives a "-...
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 ...
1
vote
2answers
142 views

How do I record a not-fully-paid expense?

I bought a pair of eyeglasses for $5 from a friend. I only paid to him $4 however as I didn't have enough cash then, so that means I owe him $1. Today I paid off the remaining $1. How should I record ...
1
vote
3answers
187 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
2answers
214 views

double entry bookkeeping loan to myself

I have 3 accounts - savings, outgoing, and loan. I have $100 in savings. I then receive $50 into savings. so far, so good. Then I want to 'borrow' $25 from savings with the intention of paying it ...
1
vote
1answer
877 views

Handling expenses for corporate tax in GnuCash

I am very new to the whole concept of book-keeping (Read GnuCash help - that's it) at the moment and was wondering if I could get some pointers in here. I am running a micro limited company (One ...
7
votes
2answers
959 views

Why is GnuCash now tracking share prices in fractions?

Prior to the update to version 3 (ie, the 2.6 branch), all my funds were tracked with decimal values. Now, they're all fractions... and odd ones, at that. Do I really care that shares went from ...
4
votes
2answers
646 views

GnuCash recreating Quicken report

I am a quicken user hoping to transfer to GnuCash. I like GnuCash a lot, but am having trouble with creating some specific reports that (IMO) are easy to create in Quicken. Specifically, I have ...
0
votes
0answers
69 views

Adding a expense category to transfer

I added a category to transfer a few years ago but I can't figure out how to do it now in GnuCash. How can I tag a transfer with an expense category?
3
votes
2answers
279 views

How do I prevent the use of duplicate invoice numbers in Gnucash?

I'm not an accountant or bookkeeper, but I have been using Gnucash to enter and manage my invoices. I had an instance where I used B192116 for an invoice number and the customer paid this invoice. A ...
4
votes
1answer
472 views

Unable to retrieve quotes in the modern GnuCash with Alpha Vantage

I have a problem getting currency and symbol quotes in GnuCash. When I open Tools - Price Database and click Get Quotes, in several seconds I see a dialog with the following text: Unable to retrieve ...
3
votes
1answer
185 views

Gnucash brokerage account with multiple stocks

GNUCash setup is driving me nuts. Most accounting software tools allow you to create a brokerage account that holds multiple securities. The account ledger can have transactions for all the ...
1
vote
0answers
154 views

How to change register colors in gnucash 3.x?

I upgraded from gnucash v2.4 to 3.4 and I read the colors theme are gone... and to follow the instruction in "https://wiki.gnucash.org/wiki/GTK3#Register_Appearance" to change them in v3.4. So I ...
1
vote
1answer
179 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 ...
3
votes
1answer
88 views

Can I visually highlight or mark transaction in GnuCash?

I was wondering if it was possible to highlight the last transaction of the month on my credit card account, for instance, so I can easily see where one credit card statement ends and another begins. ...
2
votes
0answers
42 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 ...
5
votes
2answers
649 views

How can I generate yearly statement table with details on every account on every month in a single report?

I want to know if anybody has generated GNUCash custom report with months as columns reporting Income/Expense on every account. For example: . The idea is to show the following in a single report. ...
2
votes
1answer
351 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 ...
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" ...
17
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 ...
3
votes
0answers
122 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
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 ...
2
votes
1answer
301 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 ...
1
vote
0answers
31 views

Auto pay an invoice in gnucash: make workflow simpler, by auto paying invoice (for some/most customers)

Most of my customers pay at time of doing the work. By the time I enter the invoice, they have already paid. I would like to auto pay the invoices. I would like to reduce the number of steps needed ...
2
votes
1answer
92 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 ...
0
votes
1answer
104 views

How do I specify optional modules in MacOS in Gnucash?

I'm trying to import invoices. On MacOS where do I specify (gnc:module-load "gnucash/plugins/bi_import" 0) as noted in https://www.gnucash.org/docs/v3/C/gnucash-guide/import-invoices.html
4
votes
1answer
636 views

Handling multiple currencies in GnuCash

I started using GnuCash when I used in Germany and hence I have a whole EUR structure in my database (Aktiva, Anfangszustand, Aufwendungen, Ertraege, Fremdkapital). Later, I moved to the US. I ...
4
votes
3answers
273 views

How to set up saving for items in GNUCash: Asset or Expense

Let's say I'm saving for a car and I would like to save X amount on a month to month basis, where would I generally put this?