Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
2answers
166 views

double entry bookkeeping loan to myself

I have 3 accounts - savings, outgoing, and loan. I have $100 in savings. I then receive $50 into savings. so far, so good. Then I want to 'borrow' $25 from savings with the intention of paying it ...
0
votes
0answers
36 views

Adding a expense category to transfer

I added a category to transfer a few years ago but I can't figure out how to do it now in GnuCash. How can I tag a transfer with an expense category?
0
votes
0answers
23 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 ...
4
votes
1answer
147 views

Unable to retrieve quotes in the modern GnuCash with Alpha Vantage

I have a problem getting currency and symbol quotes in GnuCash. When I open Tools - Price Database and click Get Quotes, in several seconds I see a dialog with the following text: Unable to retrieve ...
3
votes
1answer
110 views

Gnucash brokerage account with multiple stocks

GNUCash setup is driving me nuts. Most accounting software tools allow you to create a brokerage account that holds multiple securities. The account ledger can have transactions for all the ...
1
vote
0answers
57 views

How to change register colors in gnucash 3.x?

I upgraded from gnucash v2.4 to 3.4 and I read the colors theme are gone... and to follow the instruction in "https://wiki.gnucash.org/wiki/GTK3#Register_Appearance" to change them in v3.4. So I ...
1
vote
3answers
157 views

How do I record my spouse's payment in shared credit card account?

I've created a credit card liability account. My spouse shares my credit card and makes several purchases on it as well. Each of us makes a payment directly against that account at the end of the ...
1
vote
1answer
89 views

How do I unlock my Gnucash file to continue working on my accounts?

My file is Murphy.gnucash. There is a file called Murphy.gnucash.LCK in the same folder. When I open my file in gnucash, it gives me these options: Open Read-Only Create New File Open Anyway Quit ...
3
votes
1answer
59 views

Can I visually highlight or mark transaction in GnuCash?

I was wondering if it was possible to highlight the last transaction of the month on my credit card account, for instance, so I can easily see where one credit card statement ends and another begins. ...
0
votes
1answer
112 views

Gnucash - Report cash flow on a per-asset basis

I'm not sure I'm using the correct terminology but I have a number of "assets" which are sub-accounts of a checking account: Checking account - Designated funds 1 - Designated funds 2 ... What I ...
2
votes
0answers
32 views

Can't issue SEPA transaktions because account doesn't have SEPA information stored

I have Gnucash 3.4-3 and Aqbanking 5.7.8-1 installed on Arch Linux. When I try to issue a SEPA transaktion i get the error message: Your local bank account does not yet have the SEPA account ...
2
votes
1answer
157 views

How to link duplicated transactions between two accounts in GnuCash

I imported (Actions > Online Actions > Get Transactions...) transactions of my two of my accounts (bank account and credit card). Among these transactions is one that transfers money from the bank ...
3
votes
0answers
93 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. ...
1
vote
0answers
26 views

Auto pay an invoice in gnucash: make workflow simpler, by auto paying invoice (for some/most customers)

Most of my customers pay at time of doing the work. By the time I enter the invoice, they have already paid. I would like to auto pay the invoices. I would like to reduce the number of steps needed ...
2
votes
1answer
105 views

GnuCash - Show Total (Custom Currency) in Accounts view

In the Accounts view/tab, when selecting the columns to be visualized, the column Total is showing the total for each account in the respective currency (as intended). I want to see the totals in EUR ...
4
votes
3answers
194 views

How to set up saving for items in GNUCash: Asset or Expense

Let's say I'm saving for a car and I would like to save X amount on a month to month basis, where would I generally put this?
1
vote
2answers
131 views

How do I record a not-fully-paid expense?

I bought a pair of eyeglasses for $5 from a friend. I only paid to him $4 however as I didn't have enough cash then, so that means I owe him $1. Today I paid off the remaining $1. How should I record ...
1
vote
0answers
255 views

Gnucash vs QuickBooks for both personal and business account

I'm considering keeping track of both personal and business accounts. I'm an old user of Gnu cash and I think I could manage with it. What would be the benefit to swapping to a new cloud accounting ...
1
vote
1answer
85 views

Invoice Stylesheet Spacing

I'm trying to set up my invoice style in GnuCash. I've created a new stylesheet from within GnuCash but I need to make some changes to the stylesheet that aren't covered by the options within GnuCash ...
1
vote
1answer
191 views

How to change the default “Extra notes” in invoices?

It always says "Thank you for your patronage!", which I can manually edit every time I create an invoice, but how can I change it permanently?
6
votes
2answers
252 views

How to enter credit card “statement credits” (e.g. cash back) in double entry accounting? [duplicate]

A credit card statement credit is a reduction in liability, so I would think it's "income" of a sort. But, I could also see it as a reduction in expense; for example, buying a plane ticket using a ...
2
votes
1answer
78 views

Expense lower due to reimbursement. How to put in administration?

I only recently started to document my financial administration properly. Before, I had an Excel file with all transactions of my bank account (and a separate one for my savings account). Recently I ...
0
votes
1answer
151 views

How to enter loans made, loans received, and capital contributions in GnuCash?

I just started using GnuCash to keep track of my personal expenses and to do the books in my business. I have no accounting experience, but so far it's pretty simple. I've entered the balances on my ...
1
vote
1answer
89 views

Do GnuCash Income entries ever stop contributing to the Income Account's total?

I'm building a personal budget in GnuCash and after entering my starting equity, I've added my new paycheck in the Income section of my budget. I've entered it as transferred to my Checking Account ...
2
votes
0answers
34 views

How can I duplicate existing transactions and assign them to a new invoice?

I originally created a set of invoices, each with a set of itemised transactions for work done and duly sent them to my client at the time. Because he's tardy, he neglected to pay the invoices on time ...
1
vote
1answer
130 views

Bonus stocks / shares in GnuCash

What is the right way to record bonus stocks / shares received? I used Actions -> "Stock Split" menu and it created a bonus entry. When I try "Reconcile" it shows the record on both sides (Funds In ...
0
votes
1answer
159 views

Why Profit & Loss report with dollar currency summing total revenue and total expenses each $0.00

Implementing GNUCash with currency INR. Not sure why Profit & Loss report with dollar currency, summing total revenue and total expenses each $0.00 (http://rajeevbagra.blogspot.com/2018/07/gnu-...
0
votes
1answer
299 views

Moving expense transactions to different account

If I've already added an expense to 'Misellaneous' account but I later realise I should have added it to 'Office Supplies', how can I move it? I tried changing the Transfer > Expenses:Office ...
1
vote
1answer
35 views

Posting invoice in different currency

I've got all my transactions organized in CAD. Now I've got a new customer that'll pay me in USD. I can open USD bank accounts to handle this, that's not a problem but in GNUcash I created a new ...
1
vote
0answers
152 views

GnuCash/Finance::Quote not working for Vanguard funds [duplicate]

I have money in some Vanguard funds (VTSAX and VTTSX), and track my money locally in GnuCash. Some time ago, I had it set up to automatically update the prices of these funds (Price Editor → Get ...
7
votes
2answers
842 views

Why is GnuCash now tracking share prices in fractions?

Prior to the update to version 3 (ie, the 2.6 branch), all my funds were tracked with decimal values. Now, they're all fractions... and odd ones, at that. Do I really care that shares went from ...
0
votes
1answer
99 views

How do I specify optional modules in MacOS in Gnucash?

I'm trying to import invoices. On MacOS where do I specify (gnc:module-load "gnucash/plugins/bi_import" 0) as noted in https://www.gnucash.org/docs/v3/C/gnucash-guide/import-invoices.html
2
votes
1answer
166 views

gnucash: search transaction across all accounts

When I search a transaction I have first to choose an account, then by Edit - Find... I can search this account by several criteria. If there is no match I have to choose another account and repeat ...
2
votes
1answer
163 views

GnuCash Loan and Credit Card showing as debits

Setup GnuCash 2.6.12 Ubuntu 16 $10,000 loan from external party (Brandon) In the official GnuCash documentation, it states that: GnuCash treats account types Credit Card and Liability the same. ...
4
votes
1answer
222 views

How to edit a split transaction in gnucash

I have a split transaction in gnucash which transfers 10.40€ from my Checking Account (split line 3) to my Expenses:$ account (split line 1) as 20.80$ via Trading accounts: (I know 1€ is not worth 2....
1
vote
1answer
98 views

Invoices less payments in GnuCash

I use GnuCash to manage the finances for my small business. I offer prepaid accounts to my customers who don't want to be bothered with invoices or have a fixed service budget. I have set up the ...
2
votes
2answers
293 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 ...
2
votes
1answer
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
92 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
283 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
308 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
612 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
122 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
89 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
563 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
440 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
487 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
398 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
215 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 ...