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
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
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 ...
9
votes
2answers
4k views

How to delete multiple transactions 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 ...
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 ...
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
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
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 ...
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 ...
5
votes
3answers
261 views

Is there a quicker way to enter transfer account in GnuCash if you have many accounts?

I have just switched from Quicken to GnuCash. In Quicken, I could start typing any part of the category name and it would auto-suggest based on what I typed. This made it very easy to quickly enter ...
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
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) ...
3
votes
1answer
261 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. ...
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
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 ...
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
79 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 ...
3
votes
3answers
1k 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 ...
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 ...
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.
11
votes
3answers
2k views

How should I record the changing value of an investment in accounting software?

I have the following (simplistic) structure set up in GnuCash, but this should apply to other software too: Assets Bank account Pension Income Salary Interest Every month, my salary is split ...
2
votes
1answer
85 views

Importing transactions to be recorded in both 'bank checking' and 'a particular expense' account

I have been recording and analyzing transactions for several years using a spreadsheet. In effect, I have been using a variation of a single entry book-keeping system. I wish to import the data into ...
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 ...
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 ...
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 ...
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 (...
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 ...
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 ...
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 ...
17
votes
7answers
14k views

Double-entry accounting: how to keep track of mortgage installments as expenses?

Context: I am new to double-entry accounting, I use GnuCash for my personal family bookkeeping. At the moment, the main goal for me is to keep track of incomes/expenses of our family over time. For ...
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
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 ...
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 ...
0
votes
1answer
125 views

Can you define multiple hierarchies for income and expense in GnuCash?

Given the following expense hierarchy: Insurances Car insurance Health insurance Mobility Fuel Is it possible to add a different hierarchy as an alternative view on the same data such as: Health ...
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
-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 ...
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 ...
2
votes
3answers
168 views

How can I see splits relevant to an account, not just the parent transaction?

I commonly group purchases or invoices into transactions and then show the individual components as splits in gnucash. I don't know if this is the right approach, but suppose I go shopping, I might do ...
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
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 ...
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
171 views

GnuCash Chargeback

I am trying to use the chargeback function in Gnucash. The chargeback customer and job are both specified when I create the bill and the "Billable" column is checked on all items on the bill. However, ...
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 ...
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 ...
19
votes
3answers
13k 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:...
9
votes
2answers
2k views

Gnucash: Tags/ Multi-category

this is a question about if a certain feature exists of how other useres "do it": Can i attribute different or multiple cost centers to a transaction? Example: I went on holidays and paid a flight. ...
8
votes
2answers
2k views

Gnucash category structure for funds distributed across multiple bank accounts

In Gnucash, what is the best way to structure category accounts which will hold funds distributed across several bank accounts? In Canada we have Tax Free Savings accounts which return more interest ...
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 ...
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
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 ...

1
2 3 4 5 6