Difference between revisions of "Closing Books"

Revision as of 15:25, 8 April 2014

It should be noted that GnuCash reports should be able to provide accurate year-end data for accounting purposes without zeroing transactions, so book-closing may not be necessary. Leaving books unclosed does mean that account balances in the Chart of Accounts will not show Year-To-Date amounts.

Many users prefer to close the books however, and a number of approaches are described below.

Using Close Book Option

Since 2.2.4, there has been a menu item for closing the books under {Tools->Close Book}. This item creates two zeroing transactions (one for expense accounts, one for income accounts). Each account in those portions of the accounts tree is reset to zero by transferring from the equity account of your choosing.

For older versions, a not-unreasonable work around is to copy your data file, and edit it to add zeroing transactions to each income/expense account.

Other methods:

New Account Branch for Year-End Totals

Another method is to transfer your year-end Expense and Income totals to Equity. It is recommended to completely close out the previous year and archive a copy of your GnuCash data file before doing this.

Choose File->New Account and create an equity account for Year End transactions. For each expense and income account, create a transaction on the last day of the year to shift the balance out of the expense account into the Year End account. The account report for the Year End account makes a good summary of the information.

Some people prefer to make separate accounts for
Equity->Year End-> 2005 Expenses
Equity->Year End-> 2005 Income
so that the chart of accounts itself gives a nice summary year over year.

This method has the advantage that when entering new transactions, the auto-complete features will still work. It has the disadvantage that running reports that cross the year boundary will be skewed. Some people move any real transactions that occurred on December 31st to December 30th, so that reports can be run from January 1st through December 30th for the year.

One File Per Year

1. Once your current year books are complete, create an empty copy of your Chart of Accounts by selecting File->Export->Accounts. Give the empty file the name you intend to use for the new year. This will eventually become your new set of books.
2. Next, generate a Balance Sheet report in your current year file as of your closing date and print this.
3. Save the current year books to another drive location. You may wish to copy the entire directory out, as well as burn a more permanent copy to be sent offsite for safekeeping.
4. Now, open the empty copy of your books you created. Use the Balance Sheet report you printed earlier to create opening entries for each account that needs it. You can create these as multiple transactions (one for each account), or as fewer split transactions, as you prefer.

Yet Another Method

These are the steps:

1. record all transactions that occurred in current year
2. optional take inventory of all possessions - add the values to Fixed Assets
3. record the end value of all Asset and Liability accounts - these will be the opening balances (from Equity->Opening Balances) for the new year
4. zero out all income and expense accounts (transfer balance to Equity->Income$YEAR and Equity->Expense$YEAR accounts)
5. cancel all recurring transactions in current year file
6. export accounts (File->Export->Export Accounts) to new year file
7. Open new year file
8. Delete old or unused accounts
9. Create opening balance in new years Asset and Liability Accounts from values from current year (from step 3) from Equity->Opening Balances account
10. recreate recurring transactions
11. add StockQuote information - click on Tools->Price Editor->Get Quotes

jGnucashEditor

The third party tool jGnucashEditor comes with a splitter-plugin that can split your gnucash-file at a given date keeping balances, accounts, invoices, customers and stock-quotes intact.