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
1 answer
52 views

How to add a custom CSS for a predefined report in GnuCash?

I'd like to add a CSS stylesheet to the default "Balance Sheet" report. I made the CSS changes as the documentation says, but I found no way to actually use my CSS during report generation. ...
  • 11
0 votes
0 answers
44 views

Is it possible to create a static filter rule based on a text pattern in GNUCash?

Is it possible to create a static filter rule based on a text pattern in GNUCash during importing an OFX file? For example, its Import Matcher filter does not classify a transaction to a expense ...
  • 113
0 votes
1 answer
24 views

GnuCash expense piechart report not including expense account with negative value

Using the Reports->Income & Expense->Expense Piechart report, it shows the total of all expenses for the given period as expected. However, the total is incorrect as it appears to exclude ...
  • 103
0 votes
1 answer
71 views

GNUCASH: My chart of accounts is upside down at the top level

Gnucash: My chart of accounts is upside down (only at the top level) and badly sorted throughout. For instance: Imbalance-USD Trading Orphan-USD Liabilities Expenses Income Equity Assets Notice ...
2 votes
0 answers
34 views

GnuCash: How to create an expense report from individual accounts

I'd like to calculate my average monthly spend over a year from an individual asset account to an individual expense account. Is there a way to do this please? In the Expense Over Time report I can ...
3 votes
1 answer
78 views

Sharing a GNUCash file

i'm trying to use the Accounts (.gnucash) file on another computer. i just use FTP to copy it over. When i open it up - it looks alright. However when trying to use one or more Reports we have ...
1 vote
2 answers
76 views

How do we edit the dates of the General Ledger report?

We're using PCLinuxOS, updated with GNUCash also updated. We're trying to edit the General Ledger but there are very few options - only two tabs: Display and General. Is there any way to produce ...
4 votes
1 answer
107 views

What is the "current" way in GnuCash to "park" the money during a bank transfer?

I have multiply accounts which I transfer money between them, based on need. Between accounts from different bank family, the transfer takes normally few days. In this time, the money is already gone ...
  • 141
0 votes
0 answers
57 views

GnuCash budget report doesn't add up in multiple currencies

I spend in two currencies and, historically, I chose to create separate accounts under each expense line for each currency. In future I will do this differently, employing trading accounts, but what I'...
1 vote
1 answer
30 views

How to set up gnucash to use different currency pair quotes?

Some currency pairs like XAU-CHF are not available directly, is there any way to use a different currency instead of my locale?
-1 votes
1 answer
63 views

Add top-level account for both Income (Revenue) and Expenses - Other (Non-Operating) Income And Expenses (GNU Cash)

How do I create a top-level account in GNU Cash that can hold both Income and Expenses in its subaccounts? IFRS (and US GAAP) don't directly publish example Chart of Accounts, but I find it common to ...
0 votes
1 answer
36 views

gnucash How do you account for Return of Capital (RoC)

When a Return of Capital (RoC) is entered, gnucash requires a second transaction to account for the gain or loss. Similar to what happens when you sell a stock, the amount of gain/loss continues to ...
  • 223
2 votes
3 answers
87 views

Making a report with "weighted" account values

I'm trying to make a profit and loss report that takes some of my accounts such as "Expenses:Gas" and "Expenses:Automotive" and lets me apply a percentage to them (so that I can ...
1 vote
0 answers
58 views

Gnucash trial balance does not balance after entering sale of shares with unrealized gain [closed]

I have been through a few bad transactions turned up by in imbalanced trial balance in Gnucash, but this one stumps me. It seems to be different from the others. I have used the method posted a while ...
  • 223
10 votes
5 answers
4k views

In the envelope system, how often do I "clear" my envelopes?

I use digital envelope budgeting by creating subaccounts in gnucash and allocating my income between the subaccounts every month. Some expenses are relatively constant every month. Examples are ...
  • 3,121
0 votes
1 answer
151 views

GnuCash: How to transfer crypto (stock) to checking account after selling?

I have an account for cryptocurrency (USDT) which is set up as a stock account, and sometimes I pay with USDT for different goods. The expense accounts have USD currency. How do I record in GnuCash ...
0 votes
1 answer
51 views

Left panel of Account Register lacks Account Tree

How can I make the Account Register's left panel show an Account Tree, like the one in Quicken Check Register? Despite having plenty of space, GnuCash's Account tree is on a separate tab from the ...
1 vote
1 answer
89 views

GNU Cash Stocks - Using smaller than 0.01 in "Buy" and "Sell" transaction column

How can I set the value in the "Buy" or "Sell" columns to less than 0.01 in GNU Cash? I'm trying to see if GNU Cash can be used to track forex trading of cryptocurrency pairs. ...
0 votes
2 answers
141 views

How to account for depreciation and inflation adjustment on GnuCash?

I've been using GnuCash to track only my money and securities. Now, I wanna use it to track also my fixed assets so that I have a more accurate estimation of my net worth. One fixed asset I have is a ...
0 votes
1 answer
65 views

Copying invoice between .gnucash files

Is there a way to easily copy a single Invoice from one .gnucash file, to another .gnucash file?
  • 139
0 votes
1 answer
110 views

Custom Check Printing

I just downloaded GnuCash, first time user. I needed to print custom checks, but when I click on the options, all of the custom part is grayed out, non-functioning. If anyone knows what I need to do ...
  • 1
0 votes
1 answer
45 views

Universal asset-or-liability accounts in GnuCash

Some accounts can sometimes change its type between asset and liability. For example, an accounts used for tracking a friend's debt, if each of us sometimes lends money to the other, and therefore the ...
1 vote
0 answers
74 views

GnuCash : How to find net amount of two accounts in GnuCash? [closed]

I have a party, ABC, who is a vendor for one product and a customer for another. I created two accounts; one as Payable and one as Receivable. How can I check if I have to see the net amount of these ...
1 vote
1 answer
93 views

What is the purpose of the "Action" column in a GnuCash stock account?

I created a "Stock" account in GnuCash for tracking my purchase and sales of "XYZ Widget Company" stock. When I open the ledger for the account, I see that there is an "Action&...
  • 16.6k
6 votes
2 answers
720 views

How to best handle donations for a non-profit in GnuCash

I am not new to GnuCash, but have just been made accountant for a new non-profit. The law states that we have to mail tax-beneficial donation-confirmations after each year to all donors. So I need to ...
0 votes
1 answer
107 views

GNUCash Fund management fees

how can I create a transaction against a fund to reflect ongoing fund management fees? This will be a percentage of my investment that is deducted annually. It seems to me the only way to do this ...
  • 1
2 votes
2 answers
155 views

Can't I use a fractional Buy/Sell price on GnuCash that's more than 2 decimal places?

Context I want to track the transactions I made on Binance last year into GnuCash. I found out GnuCash doesn't support Bitcoin or cryptocurrencies in general, so I added them as a security, as ...
6 votes
2 answers
434 views

What accounting entries should I make for writing off a personal loan?

I loaned my father $20. This is how I recorded the transaction in GnuCash: Account Debit Credit Assets:Loans:Father $20 Assets:Banks:USD $20 Now, I want to forgive the debt. What entries should I ...
  • 16.6k
1 vote
1 answer
68 views

'temporary' USD prices in the Price Database

I've been exploring my GnuCash data and noticed something I can't explain. In the Price Database, under Currencies->USD, I have 18 entries for a currency named after the fund VFIAX. All 18 have the ...
  • 113
4 votes
1 answer
196 views

Automatically combine transfers between my own accounts

I am using Gnucash for personal use, as a new user, and whilst I have managed to arrange my accounts as I wish I have an issue with importing my bank transaction data. With my bank I have a set up ...
0 votes
0 answers
87 views

Is there a gallery with templates for budget reports for Gnucash?

Is there a gallery with templates for budget reports for Gnucash? Even better if they are ADHD-friendly and dislexya-friendly. The standard budget reports are very hard to read.
  • 113
0 votes
1 answer
64 views

Creating past transactions without affecting current checking account balance

I have started to use GnuCash as my main accounting software and I have created a brand new file with my current checking account balance. What I would like to do now is insert my past 2 months ...
4 votes
2 answers
109 views

How to account for a transfer that includes a liability

I have been trying to figure out how to use GnuCash / double-entry accounting in order to correctly enter the following situation: I have asset accounts for my bank account and for 529 accounts for my ...
  • 1,165
-1 votes
1 answer
101 views

GnuCash still being developed for Mac?

Is GnuCash still being developed for Mac? I am installing for 12.4, and it seems to work.
  • 13
3 votes
2 answers
172 views

Gnucash checkbook columns shrunk too far. Cannot get them back!

I'm working in my checkbook register in gnucash. The column headings are in green, with black vertical lines separating them. The black vertical lines between Date and Num, Num and Description, and ...
  • 101
0 votes
2 answers
80 views

Gnucash Asset Chart - Change 'End Date' to 'Yesterday' rather than 'Today'

I would like to have an asset chart to end on 'Yesterday' rather than 'Today'. I update equities based on yesterday's close value. Is there a way of hacking the scheme report code to relative . ...
1 vote
1 answer
137 views

Possible to split a transaction (already) in the "generic import transaction matcher"?

Is it possible to split a multi-account transaction (already) in the "generic import transaction matcher" - or only post-import, "manually" ? It seems really strange that that ...
  • 661
1 vote
1 answer
155 views

How to establish your (yearly) savings rate in GnuCash?

Title says it all... pretty much. Maybe this exercise is really simple and this question a bit silly: I'd guess it's simply the sum of all expenses (i.e. expense accounts) over the sum of all income, ...
  • 661
6 votes
1 answer
671 views

How do I record a purchase of gas in a gnucash chart of accounts?

Complete beginner here. Eyes sore and brain bent from reading. My question too basic for anyone to answer it seems. It is this: I start off with the new chart of accounts. I spend $50 on gas. How ...
  • 119
3 votes
1 answer
218 views

How to track business mileage in GnuCash?

I have a small business which involves some driving to clients using my personal vehicle. I track both my individual auto expenses and my mileage in GNUCash but so far have only been using the ...
3 votes
1 answer
97 views

GnuCash find transactions by account

I often have to find transactions by account, e.g. I want to find when transactions for "Auto:Fuel" in my credit card account. If I'm in my credit card register and do "Find Transaction&...
  • 133
1 vote
1 answer
163 views

GnuCash: How to build a custom report to show "fixed" vs. "variable" expenses?

I'd like to group expenses into "fixed" (e.g. rent) vs. "variable" (e.g. restaurants) expenses in a report, i.e. probably pick a couple of "accounts" and group them ...
  • 661
0 votes
1 answer
51 views

How do you change the name of the Bottom Line on the eguile Balance Sheet report?

I like the layout of the report accessed through Reports->Assets and Liabilities->Balance Sheet using eguile-gnc. But I don't like that at the end of the report, after Total Retained Earnings, ...
  • 223
1 vote
1 answer
231 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::...
  • 223
0 votes
1 answer
161 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
1 answer
402 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 ...
  • 223
0 votes
1 answer
163 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
1 answer
122 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 ...
3 votes
1 answer
208 views

Balance-dependent 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
1 answer
70 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 ...

1
2 3 4 5
7