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.
334
questions
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 ...
- 21
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 ...
- 41
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 ...
- 41
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?
- 121
-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 ...
- 148
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 ...
- 21
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 ...
- 23
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 ...
- 161
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 ...
- 23
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 ...
- 141
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 ...
- 103
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
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 ...
- 131
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 ...
- 1
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 ...
- 11
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 ...
- 51