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

What happens to the Equity::Opening Balances account over time?

I took the advice of others here and the docs when I started my GNC instance a few years ago. For the first year of operation, I chucked everything I discovered I hadn't yet tracked into Equity::...
0
votes
1answer
47 views

GNUcash: How can I add a liability payment to an asset account? (ex: I pay a personal loan of mine and someone reimburses me for it)

I have a personal loan that I pay out of my checking account and my parents reimburse me for this loan. I also share subscription services (netflix, hulu,etc) and phone bill with them and I pay for ...
0
votes
1answer
87 views

Gnucash: Balance Sheet Shows Imbalance Amount

I've been running this GNC file for over two years now. I close the books each year so that I can get YTD totals out of expense & income accounts. (see here). I have one prior year closing for ...
0
votes
1answer
58 views

Tracking realized gain in GnuCash

Let's begin with an example: I have 1000 RUB. Then I buy 10 USD with an exchange rate of 60 RUB/USD, so I have 400 RUB and 10 USD. And after that I sell 10 USD for 80 RUB/USD, so I have 1200 RUB. What ...
1
vote
1answer
45 views

Adding an Expense subaccount in a budget in Gnucash

I am learning Gnucash to do my household finances. You can easily add subaccounts to a parent account in Gnucash, but I can't figure out how to do it in a budget. When you create a new budget, it has ...
1
vote
1answer
47 views

balance-dependant scheduled transactions in gnucash

Is it possible to schedule transaction in gnucash, where the amount is not fixed at scheduling time or entered manually each time, but calculated automatically? For example, automatically transfer 5% ...
0
votes
1answer
39 views

Gnucash: Is there a way to flag a transaction?

When I'm reconciling my accounts it would be very useful if I could flag/mark a transaction. I'm not talking about using the R field. Perhaps another column that would let me mark the transaction as ...
0
votes
0answers
43 views

Gnucash: Why does the balance sheet report list positions with zero balances?

I am using GnuCash 4.8. I have opened the "Balance Sheet" report and in Options deselected "Include accounts with zero total balances". I have a brokerage account that hold some ...
0
votes
1answer
54 views

settling VAT in gnucash

I don't think I completely get how gnucash handles VAT. I'd like to settle the VAT account in gnucash. Each quarter the governments sends a bill of the total VAT owed (VAT on sales - VAT on purchases) ...
0
votes
0answers
34 views

How can I delete multiple accounts in a batch in GnuCash? [duplicate]

How can I delete multiple accounts from a batch in GnuCash? I want to delete several accounts that I created to run some tests.
0
votes
2answers
97 views

In GnuCash, how can I create a line item in an invoice that uses an expense account as the transfer account instead of an income account?

I am a freelancer; some of my clients pay me as an employee and some as a contractor. I have separate expense accounts for expenses I incur as a contractor and as an employee because as an employee, ...
0
votes
1answer
44 views

Recover gnucash mysql database transactions following cancelled import

I aborted (cancelled) an import of a small QIF file (< 50 records), and when cancelled that import fairly far along in the import dialog (the import seemed to be taking extremely long compared to ...
0
votes
2answers
87 views

Show net gain/loss for particular stock

For a particular stock that has been bought and sold a few times, is there a way to view the net gain or loss, rather than the piece-meal capital gains or losses? I found that only the current net ...
1
vote
0answers
35 views

Problems with first OFX transaction download to gnucash after using Quicken for years

I have been using Quicken for home and business for years to keep my one man office books. It does everything I need, especially auto-population of bank transactions in register for preparing ...
1
vote
2answers
83 views

What are the implications of "Change transaction contains a reconciled split?"

I am reviewing my GnuCash books. I see that back in January, my bookkeeper typed the wrong payee name when she entered a transaction. When I try to correct the payee name, I get this message: Change ...
1
vote
0answers
79 views

How can I restore a deleted column in gnuCash? [closed]

How can I restore the column, quite distressing The Withdrawal column is missing in my checking account, dragging the lines between R or Deposit does not restore the Withdrawal column gnuCash 4.6
0
votes
2answers
164 views

Gnucash chart of accounts CSV import gives error message, stock 'accounts' not imported

I am a corporate IT veteran from the financial industry with some QA experience and a Gnucash newbie. I am working on my chart of accounts setup in an iterative manner: I make adjustments to my ...
1
vote
1answer
28 views

QIF import not matching to existing transactions (Payee contains appended information)

I am downloading my banking transactions and importing into GnuCash (v3.11) via QIF. I have set up auto scheduled payments that are not being matched to imported transactions. GnuCash only seems to ...
1
vote
0answers
52 views

OFX Import in GNUCash suddenly not working anymore

I have not changed my process to generate my OFX file from my bank's pdf+csv. It worked fine last month. This time, when I try to import my ofx file, GNUCash asks me to match the account again for ...
-1
votes
1answer
155 views

Possible Bug with GNUCash - GNUCash cannot see/open files in OneDrive

I am wondering if anyone has encountered - or has a possible solution to - this bug I have found. I usually store my GNUCash file in OneDrive. However, with the new update of OneDrive, GNUCash cannot ...
2
votes
1answer
103 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 ...
0
votes
1answer
90 views

Filtering Profit & Loss Report with GnuCash

I am using GnuCash v3.11 (I'm still on Windows 7) I am tracking multiple entities (personal, wife's business, my small businesses, children, etc...) in one chart of accounts since they share Banking ...
3
votes
4answers
168 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 ...
0
votes
2answers
86 views

GNU cash - will automatically duplicate transaction

Hi sir can you please help us, our problem is whenever i add an income (not only income but also all other sales like acount) transaction , it will automatically duplicate this particular transaction ...
0
votes
1answer
69 views

How do I merge deposits to Checking/Savings into a split transaction for Salary in GnuCash?

I just started using GnuCash for personal use and am just as new to accounting, other than some college courses decades ago. I am able to import Checking and Savings transactions from my credit union (...
2
votes
1answer
123 views

Using functions e.g. round in GnuCash Scheduled Transaction

I use scheduled transactions in GnuCash and it works, even with user input. What I am missing, that when I enter a user input for a scheduled transaction and use this value in a calculation then I ...
0
votes
1answer
72 views

Gnucash OFX import transaction dates are wrong?

I have exported transaction data from my credit card company in OFX format. When I import it into Gnucash, the dates that show for the transactions are off by a day or two compared to the dates on my ...
2
votes
1answer
129 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
2answers
98 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
0answers
43 views

Correcting a transaction -- Gnucash won't let me do it [duplicate]

I have been experimenting with splitting transactions so posted a question about it on this forum. The answer I received did the trick and I can now split transactions just fine. The trouble I'm ...
3
votes
1answer
140 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 ...
0
votes
1answer
91 views

GNUCash — Adding Namespace Item to Price Editor

In the Price Editor in GNUCash you have to choose from a list of seven items: Currencies, All non-currencies, AMEX, EUREX, FUND, NASDAQ and NYSE. Is there any way of adding an item to this list? I ...
0
votes
1answer
33 views

GNUCash Totals On Expense Chart

Is there anyway of getting the totals of each bar in the Expense Cart in GNUcash? Each bar is broken up into different accounts by color, see screen shot below, and you can get the numbers for each ...
5
votes
2answers
157 views

In GnuCash How to sort credit before debit

Is there a way to sort credit before debit for the same day? It seems the order is by time of entry, I understand that I can cheating it by entering credit first, but sometimes it's not possible, so ...
0
votes
1answer
69 views

Reconciliation uses different number than entered

I'm doing a year-end reconciliation of one of my expense categories. In the reconcile-setup window, I enter the amount $36,387.59 for the ending balance: However, the amount shown in the subsequent ...
1
vote
1answer
92 views

limit number of backup files

Gnucash defaults limit of backup file to days instead of number of files, so if gnucash is opened for several hours, there could be many backup files. Is there a way to limit the backup of files to a ...
1
vote
1answer
108 views

Combine bill and invoice in a single transaction

I would like to combine some bills (that I need to pay) and some invoices (that I'm being payed) into a single transaction so that it is correct with my bank statement. Is this possible? I work as an ...
2
votes
1answer
102 views

How to enter a tax credit/deduction/exemption in double entry system?

I started using GnuCash and have learned the basics of double entry bookkeeping for managing rental income. I have managed to create a working Chart of Accounts that works well and accurately (...
2
votes
1answer
496 views

gnucash: How to set currency of a stocks account? Moving stocks from one stock account to another with different currencies

I am using gnucash for tracking my stocks, ETFs and cryptocurrencies. For the latter, I often heard the recommendation to treat them as a security. As such, I added a CRYPTO namespace in the ...
2
votes
1answer
128 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 ...
1
vote
1answer
85 views

Importing brokerage QFX files into GnuCash

I'm trying to figure out how to import QFX files from my brokerage into GnuCash. I have read the documentation about investments here, but I'm having some problems getting it to work correctly. First ...
5
votes
0answers
121 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 ...
0
votes
0answers
61 views

Half down; half on delivery - How do you invoice that?

I know of a business that charges $100 for a repair. They charge $50 on acceptance of the job, then $50 on delivery. One could issue two invoices, tying them together with a job for the customer. Post ...
1
vote
1answer
123 views

SOLVED - What's the right way to process a customer's overpayment?

A customer overpaid me by $4. When I processed the payment (business->customer->process payment), it left me with a $4 imbalance, as there was no invoice to apply that to. I decided to try ...
1
vote
0answers
38 views

Import Match migrate to a new file

I'm using Gnucash 4.2 on Windows 10. For my old file I have imported transactions and pretty much all my imports have "Import Match" now. However, when I start a new file, all the "...
1
vote
1answer
126 views

Recording Personal Loan

If I put $200 of groceries on my credit card for a friend while I'm out shopping, how do I record that transaction? Further, when she pays me back by bank transfer, how do I record that transaction to ...
1
vote
1answer
100 views

GnuCash Reconcile Fractured Payments

First-time listener; first-time caller. For reasons I don't quite grok, Amazon sometimes places multiple small transactions on my credit card for a single invoice. For Example, a recent invoice of $38....
2
votes
1answer
158 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 ...
0
votes
1answer
408 views

GnuCash not opening mysql database on Windows 10

I have a mysql server on my Ubuntu 20.04 server on a local network as the backend for my GnuCash installation. I can connect with no trouble using an SSH tunnel from my Ubuntu 20.04 desktop. However, ...
1
vote
0answers
217 views

GnuCash with (optical) PhotoTAN?

With Ubuntu 20.04.1 I now installed GnuCash - both as Flatpak (version 4.1) and from the official repos (version 3.8) and am nothing less than flabbergasted that online banking still won't just work ...

1
2 3 4 5 6