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

How to record currency exchange in double entry

I decided to make my own double entry accounting program that deals with multicurrency. However, I am facing an issue in dealing with following scenario: I have two bank accounts: From: Opening ...
1
vote
1answer
501 views

GnuCash, how do I book loan from credit card, being paid back with salary? [duplicate]

I am doing double-entry bookkeeping with GnuCash to track my personal finances. Sometimes I spent money on expenses which my employer is supposed to spent, and I later get reimbursed. For example, I ...
1
vote
2answers
5k views

How to account for Unrealized Gains in a Trial Balance?

Using GnuCash, When I run a Trial Balance on my accounts, my Debits exceed my Credits by 875.00 wich is the same amount of my Unrealized Gains on the Balance Sheet. How do I reconcile this in my ...
1
vote
3answers
313 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 ...
1
vote
1answer
180 views

GnuCash to track expenses when refunds occur

I've started using GnuCash to keep track of my expenses so that I have an idea of how much I spend each month for food, clothing, etc. My main goal is to be able to see if I went out of budget one ...
1
vote
1answer
150 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 ...
1
vote
2answers
505 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 ...
1
vote
2answers
131 views

How to register obligatory social insurance?

Every month I have to pay a certain amount as social insurance. It is my debt - I have to pay regardless of my income. What should be the source of this debt? Opening balance from equities branch? ...
1
vote
2answers
2k views

Accounting for paying bills for (and being reimbursed by) another person

I an currently using Gnucash to manage my expenses. I am new to double-entry accounting and find many aspects of it to be confusing. Here's a situation that currently happens monthly. I'd like to know ...
1
vote
1answer
4k views

Salary account in gnucash: charge vs. income // example transactions

It might not be the usual thing to have on opening balance in a "Salary" account, but if one did, this is what I tried in gnucash: description: payday again :-) transfer: Equity:Opening Balances ...
1
vote
1answer
67 views

Including benefits in kind within accounts

I'm producing accounts for a local political party using GNU Cash. There are a lot of benefits in kind that we need to account for. Previously I included these on a separate spreadsheet, but would ...
1
vote
1answer
327 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?
1
vote
1answer
50 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
1answer
137 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 ...
1
vote
1answer
333 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 ...
1
vote
1answer
153 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 ...
1
vote
1answer
174 views

GnuCash How to track a bill in A/P and in an asset account and get tracked to customer who reimburses

I incur expenses on behalf of clients who will reimburse. In quickbooks i would create bill to vendor and track to customer. expense went to A/P and the the other entry was an asset account. This ...
1
vote
1answer
342 views

How do I join transactions after importing from multiple bank account statements in GNUCASH?

I found this but I don't feel it really solves the issue. When importing from two mt940 statements, which have transactions between each other, how can they be "joined" as double entries between the ...
1
vote
1answer
3k views

List of banks with free OFX service [closed]

I am looking for a list of banks that offer a free OFX (Open Financial Exchange) service. The best list I have been able to find is here: OFX List Some of the banks on this list are documented to ...
1
vote
1answer
523 views

How do I create a Custom Bar chart report in GnuCash?

I'm trying to create a custom bar chart report in GnuCash 2.6.5, similar to the Asset Bar Chart or Liability Bar Chart. What I need is a report that shows the sum of 3 (or more) accounts. Some are ...
1
vote
1answer
672 views

How can I find out in GnuCash how much I have spent in a given time period?

I started doing double entry bookkeeping with GnuCash to keep track of my personal finances, down to the penny. I think I am familiar with most of the basics of double entry bookkeeping, I took a ...
1
vote
1answer
730 views

How can I import customers and invoices from a previous year's Gnucash file?

I've been using Gnucash for the past year for small business accounting as a self-employed contractor. I've read that it's a good practice to create a new file for each year. Now that 2014 has ended,...
1
vote
2answers
577 views

Representing a personal loan with double entry

I have received a family loan (no interest or penalties, just a friendly loan) from my parents which is deposited into my savings account for my bank. I'm having issues understanding how I should ...
1
vote
1answer
287 views

Dealing with temporary accounts

I use Gnucash for managing my finances. When I receive a gift card, I assume that it should be it's own account as one of my Current Assets. However, once that gift card is fully spent or expired, ...
1
vote
1answer
620 views

Splitting already paid bills with housemate

I live with a house mate, and we split our grocery expenses 50/50 between us. Everything is done in cash. I use GnuCash to manage my finances, and I'm not sure how such a situation can be recorded: ...
1
vote
1answer
86 views

How do I write off an invoice in GnuCash?

I've tried 3 ways pay the invoice and then record a debit offsetting the payment. Messes up the totals but the balance is the same. pay the invoice and then apply a 100% refund in the payment ...
1
vote
2answers
144 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
1answer
106 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
111 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 ...
1
vote
1answer
106 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 ...
1
vote
1answer
568 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 ...
1
vote
2answers
866 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 | ...
1
vote
1answer
410 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
550 views

Liability showing up as asset in Equity

I am getting up & running in GNUcash. I however am puzzled by the Loan and Equity:Opening balance results. I should note that this money for the student loan was spent years ago, so I entered my ...
1
vote
2answers
1k views

How to print account transactions for a time period in GNUCash?

I would like to print all the transactions for an account from, for example, 01/01/2015 to 31/12/2015. I found the report in Reports > Account Reports but that displays all the transactions in the ...
1
vote
1answer
214 views

'Category' and 'Budgetary imputation' in Gnucash

Currently using grisbi to manage my personal money, I'm considering moving to gnucash (as it seems to fulfill my needs, to have better dev support and some functionalities I am missing -- e.g. sub-...
1
vote
1answer
915 views

Handling expenses for corporate tax in GnuCash

I am very new to the whole concept of book-keeping (Read GnuCash help - that's it) at the moment and was wondering if I could get some pointers in here. I am running a micro limited company (One ...
1
vote
1answer
338 views

How can I easily show difference between Current Assets and Current Liabilities in Gnucash?

So I have a subaccount of Liabilities named "Current Liabilities" and I'd like to have an easy access to the value of [Current Assets - Current Liabilities] (kind of my personal "Working Capital"). I ...
1
vote
0answers
49 views

Capital Gain report with currency conversion of purchase cost

I have setup gnucash in my windows laptop. It does what I want and it does flawlessly. I have one question though. My default currency is AUD. I have investments in shares in indian currency. Using ...
1
vote
1answer
120 views

Modeling joint expenses in gnucash

I want to set up gnucash to register the house expenses and be able to see how much money I should return to my wife or her to me every month. The situation is as follow: We share common expenses ...
1
vote
0answers
264 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
0answers
32 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 ...
1
vote
0answers
426 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
0answers
237 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 ...
1
vote
1answer
59 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 ...
1
vote
0answers
122 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 ...
1
vote
0answers
238 views

How to calculate the interest on an account wth GnuCash?

I have a loan from the owner liability and expenses paid from this account. I have not setup the interest rate on this loan, and the loan account is added to in infrequent amount as expenses come up ...
1
vote
1answer
604 views

GnuCash register reimbursements

I just started using GnuCash for personal finance, and I'm still figuring out how to register different types of movements of money. The issue I'm not sure about now, is how to register ...
1
vote
2answers
522 views

How to record “short premium” in double-entry accounting? [closed]

I write (sell to open) puts on margin for “short premium” on my personal account. The contract note for an opening transaction lists a number of components: • contract number • option symbol • strike ...
1
vote
1answer
384 views

Gnucash creating transactions for wrong account in import

Something seems to be broken in the setup of my online accounts: whenever I get transactions for one of my accounts (via HBCI), Gnucash creates transactions for a different account and also looks for ...