Book Image

Gnucash 2.4 Small Business Accounting: Beginner's Guide

4 (1)
Book Image

Gnucash 2.4 Small Business Accounting: Beginner's Guide

4 (1)

Overview of this book

Attention, small business owners! Stop tax-day stress. Stop procrastinating with a shoebox full of receipts. Stop reinventing the wheel with a spreadsheet. Stop making decisions simply on a hunch. Stop wasting money on software that is overkill. Start by downloading GnuCash and getting your accounts in order. Designed to be easy to use, yet powerful and flexible, GnuCash allows you to track bank accounts, income, and expenses. As quick and intuitive to use as a checkbook register, it is based on professional accounting principles to ensure balanced books and accurate reports. You can do it and Gnucash 2.4 Small Business Accounting Beginner's Guide will help you get up and running with maintaining your accounts. Gnucash 2.4 Small Business Accounting Beginner's Guide speaks business language, not accountant-speak, because it is written by a former small business owner. It guides you to use GnuCash from scratch with step-by-step tutorials without jargon, pointing out the gotchas to avoid with lots of tips. It will teach you to work on routine business transactions while migrating transaction data from other applications gradually. You will be able to keep on top of transactions and run reports after reading just three chapters! Beyond Chapter 3, it is up to you how far you want to go. Reconcile with your bank and credit card statements. Charge and pay sales tax. Do invoicing. Track payments due. Set up reminders for bills. Avoid stress at tax time. Print checks. Capture expenses using your mobile phone. Gnucash 2.4 Small Business Accounting Beginner's Guide gives you the power. Know your numbers. Make decisions with confidence. Drive your business to its full potential.
Table of Contents (20 chapters)
Gnucash 2.4 Small Business Accounting
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Time for action – exporting data from GnuCash for migration and other purposes


Let us say you are trying to migrate to another accounting and bookkeeping software. That software requires either a CSV file or a QIF file for importing. In this tutorial, we will see how to create a CSV file of all the transactions in GnuCash:

  1. Prerequisites: Make a backup of your accounts data file first.

  2. From the menu, select Reports | Transaction Report. Open the Report Options dialog and unselect Totals, Subtotals, Account Name, and Secondary Keys, leaving only the main headers other than the transactions. The Transaction Report will now appear as shown in the following screenshot:

  3. From the menu, select File | Export | Export Report to export that report as an HTML file.

  4. Open this HTML file in your favorite spreadsheet program.

  5. Delete all the header rows, leaving only the transaction data. Select the amount column. Change the format so that the 1000 separator comma is removed. Save this file first in the spreadsheet...