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.
347
questions
-2
votes
2
answers
81
views
Titles and double booking entry not valid after move new pc [closed]
I moved my Gnucash files between PCs. I transferred all Gnucash files at my particular location that I consider for further moving process and keep them particularly in a folder then transferred them. ...
- 97
1
vote
0
answers
49
views
Gnucash Quote data from other than Alphavantage
As on today, Alphavantage seems to throttle 25 requests/day on free account.
As we see other provides like Fool/Fidelity Direct etc,
Can somebody help configuring gnucash quotes retrival with source ...
- 93
0
votes
2
answers
38
views
Start gnucash specifying with set of books
I have two regularly used gnucash sets of books. My finances and those of my aged parents. Is there a command line option by which I can select which set of books open, or am I only limited to the ...
- 101
1
vote
1
answer
52
views
How account for capitalised expense in personal accounting software (gnucash)?
I'm using gnucash to record the purchase of an investment property and some expenses that are considered part of the cost base of the property. These include:
Settlement costs
Stamp duty
Renovations ...
- 201
1
vote
1
answer
94
views
GnuCash: How to assign a checking account from which a bill will be payed
Description
I'd like to properly account for purchases (e.g. on Amazon).
In most cases, when I purchase an item the merchant sends me the package and only after a couple of days credits my bank ...
- 11
1
vote
1
answer
97
views
Query about double entry going to wrong column
I have just started using GNU Cash and most accounts I have been able to set up without any major issues.
But have a query on how can we reverse columns for some entries?
Let me start with a couple of ...
- 13
1
vote
1
answer
94
views
How do I close my account in GNUCash
I am not a Accountant or GNUCash expert so I am seeking help. Let me set the stage. I am from India, here we have investment option called Fixed Deposit abbreviated as FD (in USA I think they call it ...
- 11
0
votes
1
answer
100
views
GnuCash: Should I Record Fraudulent Charges?
I'm catching up on reconciling my checking account in GnuCash, discovered a fraudulent charge on the February 2023 statement, and noticed another fraudulent charge pending. Should I enter the ...
- 103
0
votes
1
answer
27
views
Which category for scholarship money in GnuCash
I use GnuCash for home accounting. In particular I use it to keep track of college expenses. Where should scholarship money received from the college go? One side of the entry will be a reduction of ...
- 453
0
votes
0
answers
40
views
Gnucash imported QIF file not working the same as Quicken - all debits
Good morning:
I am a first time poster, long time user of gnucash...
I am trying to import a QIF file into gnucash. Gnucash is entering everything as a debit. I can't verify this but am being told ...
- 1
3
votes
1
answer
112
views
GnuCASH - How to split a single bill in multiple due dates for payment?
It happens often that I have a single bill from a vendor and the payment is split along multiple dates, but I can't get how to do that and Gnucash docs don't explain it much.
So far, I split the bill ...
- 31
0
votes
2
answers
112
views
How can I track gift money in GnuCash?
I'm fairly new to GnuCash and this kind of accounting. I'm trying to work out how to receive gift money as cash and spend it via a credit card.
I've also started looking at reports so I can see how I'...
- 103
6
votes
1
answer
1k
views
Gnucash Mutual fund changes number I enter
In GnuCash, I have tried setting up a mutual fund similar to the Stock Account example in 9.4 of the GnuCash manual, but as a Mutual Fund. The account that I set up looks something like this (example ...
- 163
0
votes
1
answer
285
views
gnucash says it can't obtain the lock. "Open anyway" fix fails
I'm new to this forurm so please forgive me if I'm violating decorum.
I'm moving gnucash 4 to a new computer, just like I've done in the past. Both run windows 10. This time, I'm getting the "can'...
0
votes
1
answer
188
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.
...
- 9
0
votes
0
answers
91
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
44
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
145
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 ...
- 101
2
votes
0
answers
81
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
169
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
127
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
155
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
96
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
50
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
141
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 ...
- 214
0
votes
1
answer
75
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 ...
- 233
2
votes
3
answers
99
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
94
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 ...
- 233
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,203
0
votes
1
answer
263
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
52
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
137
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
236
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 ...
- 43
2
votes
1
answer
86
views
Copying invoice between .gnucash files
Is there a way to easily copy a single Invoice from one .gnucash file, to another .gnucash file?
- 159
0
votes
1
answer
168
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
84
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
78
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
211
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.9k
6
votes
2
answers
796
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 ...
- 181
0
votes
1
answer
158
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
4
votes
2
answers
252
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 ...
- 43
6
votes
2
answers
461
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.9k
1
vote
1
answer
73
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
5
votes
1
answer
388
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 ...
- 151
0
votes
1
answer
80
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
170
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
107
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
337
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
100
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
229
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 ...
- 691