We’re rewarding the question askers & reputations are being recalculated! Read more.

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
2
votes
2answers
382 views

How to only show transactions between a specified date range in GnuCash?

I'm still new to GnuCash so please bear with me: My business has year end 03/31 and I was wondering if I can select a date range so that it shows me transactions within the range? Or am I supposed to ...
3
votes
2answers
1k views

How to delete multiple transaction 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
100 views

Copying account balances into new book

Each semester, the treasurer of our fraternity sets up a new gnucash file, based on a template without any transactions (just the accounts already created). For each active member, the majority of ...
2
votes
1answer
317 views

Tracking employee stock option grants in GnuCash

I've been using Gnucash for a while now and I'm starting to feel like an accountant. :) Anyway, I've been interested in trying to map out employee stock option grants for a while to form a more ...
0
votes
1answer
367 views

GnuCash Cashflow Report Account Display Depth

In a GnuCash Cashflow report how can i change the "Account Display Depth" of the sections? Money into selected accounts comes from Money out of selected accounts goes to Detail: In GnuCash's ...
5
votes
2answers
855 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. ...
4
votes
1answer
3k views

Importing .csv into GnuCash

Exported my Expenses Sub Account from GnuCash as .csv file and got the undermentioned 16 column headings. Date Account Name Number Description Notes Memo Category Type Action Reconcile To With Sym ...
8
votes
1answer
141 views

Gnucash: Keeping track of sales and expenses for a specific craft show

My wife is an artist, and is beginning to do craft shows. I want to be able to track the profitability for each show by collecting expenses and sales. Expenses can occur up to a year in advance of the ...
3
votes
1answer
97 views

How to get visibility into contributions to assets

I'm using double entry with Assets, Expenses, Income, Liabilities, and Equity. To illustrate my question with easy round numbers: Income one month is 10k; 5k goes into an asset like a 401k account (...
5
votes
1answer
756 views

Organizing portfolio in gnucash: Now what?

I started to manage my stocks in gnucash as described in the manual and I update the prices frequently with Finance::Quote. But now what? What are the useful reports that I can generate from the data?...
5
votes
2answers
622 views

How can I generate yearly statement table with details on every account on every month in a single report?

I want to know if anybody has generated GNUCash custom report with months as columns reporting Income/Expense on every account. For example: . The idea is to show the following in a single report. ...
3
votes
1answer
629 views

Tracking Stocks in gnucash: Total mount shown in the ledger is wrong

I recently started buying some stocks and track them with gnuCash. I used the gnuCash manual to get started. Basically I have Assets:Broker Account where I transfer money. From this account I buy ...
4
votes
2answers
453 views

gnuCash: Selling a car

I bought an old car two years ago for 4000$. Now I am selling it for 2000$. Meanwhile I had much repairs which exceeded all the prices. Determining the value of such an old car is hard. Once upon a ...
0
votes
0answers
285 views

GnuCash: Paying for others - direct or indirect transfers?

Suppose I am going to a restaurant with 5 friends. Suppose we are in the US because then we have to pay together. Suppose I take the bill of 500$ with my credit card. I receive the money of one friend ...
2
votes
1answer
135 views

How to make entries for a cancellation fee & return in GnuCash

I have booked some flight tickets using Debit Card and then later had to cancel them. I received part of the money after cancellation fee is deducted. What is a good way to record this type of ...
4
votes
1answer
602 views

Handling multiple currencies in GnuCash

I started using GnuCash when I used in Germany and hence I have a whole EUR structure in my database (Aktiva, Anfangszustand, Aufwendungen, Ertraege, Fremdkapital). Later, I moved to the US. I ...
1
vote
1answer
55 views

Gnucash: how to add multiple rates in the price scatterplot

If it is possible, how can I add multiple investment rates/currencies/etc within a single price scatterplot? I know how to add one rate. I just want to have this report for myself. Or, as a first ...
3
votes
1answer
757 views

How to account for digital currencies in a double ledger book

I put my personal finance records in GnuCash and I would like to understand how to best account for digital currency transactions. My book is for tracking EUR transactions. Scenario 1: I hold 1 BTC ...
1
vote
1answer
302 views

Missing transaction in Gnucash import from OFX, transaction is in the file

I'm exporting my bank history using OFX format and GnuCash can import it ok, but sometimes there are a few transactions that are in the bank history, are in the OFX file, but GnuCash refuses to show ...
3
votes
0answers
83 views

How do I see how much savings I will have at the end of the budget period with GnuCash?

I have set up a budget in GnuCash for a one year period, and I started out with some money in each of my accounts. How do I find out how much money I will be left with at the end of the budget period? ...
3
votes
1answer
170 views

GnuCash: expense tracking/amounts left under limits

So I've decided I want to try and rein in my spending a bit, and keep my money a little more under control, and while I know there are more simple expense tracking programs, I'm not one to use a ...
10
votes
4answers
9k views

How to fix Finance::Quote to pull quotes in GnuCash

I made the jump from Jumsoft's Money app to GnuCash a while back. It appealed to all my OCD tendencies. I don't know how to use Perl, or stuff of the sort, but with detailed instructions I manage to ...
2
votes
1answer
345 views

How do I deal with initial transactions from online banking

I've just set up gnucash to pull transactions from one of my credit card accounts. It works and the transactions are imported; however, the account balance listed is wrong. I think this is because it ...
2
votes
1answer
584 views

GnuCash Conversion from Quicken

I successfully downloaded GnuCash and linked it with my Quicken data files. But now all my account information is scrambled--bank balances up or down by an order of magnitude, securities sold long ...
2
votes
1answer
146 views

How do I pick the location where Gnucash backs up to?

I would like to back up Gnucash to a external hard drive. Latest Gnucash version and latest Mac OS 10.12.6.
4
votes
1answer
1k views

Import stock transactions from Excel to GnuCash

I'm trying to automatize the process of import financial data from my stock broker to Gnucash. I'm looking for a way of export the Excel data from my broker to QIF of other suitable format to be ...
1
vote
1answer
477 views

Super GnuCash placeholder account

I am keeping all my daily money transactions in GnuCash and I am loving it. I started to use it also to keep the records of my new small business at home. I'd like to have all kinds of accounts of ...
3
votes
1answer
193 views

Gnucash fee option

My problem is that I can't handle translations with fees using gnucash. For example, I have an account that represents my bank account. I'd like to withdrawal $100 and my bank will also charge me ...
11
votes
3answers
1k views

How to account for months lapse in tracking finances

I have been tracking my finances with GnuCash since the beginning of this year. All was good until summer hit and I spent more than two months traveling, but I'd like to get back to it without the ...
0
votes
1answer
541 views

How do you set up current year bookkeeping based on previous year balance sheet and profit and loss items?

I'm setting up this year's accounting ledger for a sole proprietorship. It used to be done by CPAs in the past but I decided it's time to bite the bullet and start doing it myself. All is going well,...
2
votes
2answers
371 views

Book capital losses in gnucash

I have an asset in gnucash, and its value changes over time. I followed these instructions and know how to record the gains, but it's unclear to me how I record the losses. The help page describes ...
2
votes
0answers
259 views

Gnucash budget report not adding subaccounts

I have problems budgetting for accounts that contain subaccounts. Gnucash does not seem to want to add the actual values in the subaccount, to get the correct value for the parentaccount, but in stead ...
4
votes
2answers
936 views

How separate individual expenses from family expenses in Gnucash?

After discussing the finances with my spouse I realized that there is no way to easily determine whether an item was purchased as part of our individual accounts, or our combined family account. ...
3
votes
1answer
494 views

Setup Rental Security Deposit account in GnuCash

I'm new to GNUCash and creating a new GNUCash file to track my rental. I have a security deposit account with my bank, and am trying to make sure I get this all setup correctly. In quicken, I had an ...
1
vote
0answers
115 views

GnuCash expense report by account with multiple currencies

I'm trying to report the total value of my business expenses over a tax period. My expenses are recorded under Expenses in ZAR (primary currency) and some hosting expenses are recorded in USD. When I ...
3
votes
2answers
690 views

How would I set up an account in GNUCash to track savings and coupons

My goal would be to track the so-called "savings" I get from the grocery store or pharmacy when items are bought on sale. (That way I can really save by putting that money aside) But I'm not sure how ...
4
votes
2answers
636 views

GnuCash recreating Quicken report

I am a quicken user hoping to transfer to GnuCash. I like GnuCash a lot, but am having trouble with creating some specific reports that (IMO) are easy to create in Quicken. Specifically, I have ...
1
vote
2answers
750 views

Link bank transactions for credit card payments in GnuCash?

Using GnuCash. I download activity from my bank and from my credit card. I've imported my bank activity and that will have entries such as Date | Description | Withdrawal 1/1/2017 | ...
3
votes
1answer
94 views

Find cost for specific investment over last year in GnuCash

I have a mutual fund account containing purchases over several years. Each year there are many individual purchases. The "Balance" column is useful for telling me the total number of shares purchased ...
4
votes
2answers
581 views

GNUCash: How to count up equity?

I'm new to getting my finances in order, and I've decided to use GNUCash to track my spending and general financial health. I'm reading the manual and trying to take control! My trouble and ...
5
votes
1answer
744 views

GnuCash - How should equity accounts be adjusted for profit/loss in a partnership?

I have an LLC with 3 members, and have created an equity account for each member. I have a transaction that debits the checking account and credits the equity account for each member's contribution ...
3
votes
2answers
330 views

How to make wrong amount in gnucash account in line with real amount?

My checking account shows a value that is higher then it actually is according to my bank statement. As far as I know I've only added transactions that have already been processed, so it should be the ...
1
vote
1answer
386 views

gnucash share fractions

For tracking shares in GnuCash, the maximum number of decimal places allowed seems to be 8 (100 millionth) but I'm dealing with fractions with 9 decimal places. Any extra decimals after 8 get ...
1
vote
1answer
148 views

Remove VAT amounts from cash flow report

I am using Gnu Cash to track my personal expenses as well as my freelancing income. On some of my income I receive VAT which I then have to pay back. Currently the income/expense cash flow report is ...
2
votes
1answer
445 views

Coding Expenses to Vendors Without Entering a Bill in GnuCash? [closed]

In QuickBooks, when using the "Batch Transactions" window to enter transactions, I can allocate the transaction to a vendor without creating a bill. I.e., when I charge an "Office Expense" for copy ...
3
votes
1answer
125 views

Full amount spent on Liabilites GNU cash

I would like to have a total of just the charges on a liability such as a VISA card. Take out the payment data.
2
votes
2answers
660 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
2answers
483 views

GnuCash setup for personal and shared money in the same account

I have arrangement with my spouse that everything that we earn is "shared" but we get monthly allowance that is personal. We get our salaries to personal accounts and tract how much we owe to in ...
3
votes
2answers
275 views

How do I prevent the use of duplicate invoice numbers in Gnucash?

I'm not an accountant or bookkeeper, but I have been using Gnucash to enter and manage my invoices. I had an instance where I used B192116 for an invoice number and the customer paid this invoice. A ...
4
votes
1answer
636 views

How can I export transactions from GnuCash including references to associated files

I can add files to transactions using menu Transaction > associate file with transaction to assign files. I want to export the transactions in a way so that this file reference it included in ...