Gnucash 2.4 Small Business Accounting: Beginner's Guide


Gnucash 2.4 Small Business Accounting: Beginner's Guide
eBook: $26.99
Formats: PDF, PacktLib, ePub and Mobi formats
$22.94
save 15%!
Print + free eBook + free PacktLib access to the book: $71.98    Print cover: $44.99
$44.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • Help small businesses maintain their books of accounts using feature-packed, easy-to-use GnuCash
  • Written by an author who has "been there, done that": who ran two small businesses, understands the needs of small businesses, and guides you to effectively use GnuCash
  • Instead of simply describing the features of the software, this book focuses on how to use this software to plan, get the right numbers, and make the decisions to reach your business goals
  • While beginners can get started quickly, advanced users will find lots of features such as migrating transaction data and integration with other applications that they didn't know existed or could be used that way
  • Written without accounting jargon and with lots of hands-on tutorials, multiple choice questions to check your understanding, and additional challenges thrown at the more adventurous user, in an easy-to-read style

Book Details

Language : English
Paperback : 324 pages [ 235mm x 191mm ]
Release Date : February 2011
ISBN : 1849513864
ISBN 13 : 9781849513869
Author(s) : Ashok Ramachandran
Topics and Technologies : All Books, Other, Beginner's Guides, Open Source

Table of Contents

Preface
Chapter 1: Getting Started with GnuCash
Chapter 2: Transactions – the Lifeblood of a Business
Chapter 3: Fun and Eye-opening Part - Reports and Charts
Chapter 4: How not to Get Lost in the Transactions Jungle
Chapter 5: Repetitive Work? Let GnuCash do it
Chapter 6: Business Mantra: Buy Now, Pay Later
Chapter 7: Budget: Trip Planner for your Business
Chapter 8: Making Tax Times Less Stressful
Chapter 9: Printing Checks and Finding Transactions
Chapter 10: Adapting GnuCash for Non-profits and Personalizing
Chapter 11: Data Import/Export: Use your Phone to enter Expenses
Chapter 12: Application Integration and Other Advanced Topics
Appendix: Pop Quiz Answers
Index
  • Chapter 1: Getting Started with GnuCash
    • Installing GnuCash on Windows
    • Time for action – installing GnuCash on Windows
      • Other operating systems
      • Other download locations
    • But first, a tip to make your life easier with auto-save
    • Taking the drudgery out of setting up accounts
    • Time for action – creating the default business accounts
      • Account hierarchy
      • Minimal set of accounts
    • Getting your business accounts done just right
    • Time for action – fine tuning business accounts
      • Account types
      • Parent accounts and top level accounts
      • Placeholder account
      • Opening balance
    • How to impress your accountant
    • Strengths and limitations of GnuCash
      • Business as well as personal accounting
      • Single user
        • Sharing a GnuCash accounts file
      • Accounting features not supported by GnuCash
      • Business functions other than accounting
    • Summary
    • Chapter 2: Transactions – the Lifeblood of a Business
      • A quick and easy way to enter simple transactions
      • Time for action – entering simple transactions quickly and easily
        • Money makes the business world go round
          • Simple transaction
          • Checks and balances are good
      • Entering a simple transaction in the account register
      • Time for action – entering a simple transaction in the account register
        • Navigating the account registers
          • Jump to account
        • Divide and conquer
          • Examples of simple transactions
      • Entering a more complex transaction in the account register
      • Time for action – entering a split transaction in the account register
        • Visualizing split transactions
          • Examples of split transactions
        • Tips for entering split transactions
      • Anybody can change their mind
      • Time for action – editing, cancelling, and deleting transactions
        • Save time by using shortcuts
          • QuickFill
          • Data entry shortcuts
          • Navigation shortcuts
          • Computation shortcuts
      • A feeling of déjà vu
      • Time for action – reusing transactions
        • Changing the register views
          • Deleting a transaction in different views
        • Text information in transactions
          • Transaction description
          • Transaction notes
          • Transaction number
          • Split action
          • Split Memo
      • Summary
      • Chapter 3: Fun and Eye-opening Part - Reports and Charts
        • Viewing standard reports and charts
        • Time for action – viewing standard reports and charts
          • Reports and charts
            • Income Statement (Profit and Loss Statement)
            • Balance Sheet
            • A chart is worth a thousand numbers
            • Other reports
        • Creating a custom report and saving it
        • Time for action – creating a custom report and saving it
          • Tips for customizing reports
          • Tips for customizing charts
          • Sample & Custom Reports
        • Working with stylesheets
        • Time for action – working with stylesheets
        • Exporting reports
        • Time for action – exporting reports
        • Summary
        • Chapter 4: How not to Get Lost in the Transactions Jungle
          • How not to get lost while hiking in the wilderness
          • Manual reconciliation
          • Time for action – reconciling with a printed monthly statement
            • Points to note about reconciling
            • Can I edit or delete reconciled transactions?
              • Mark split as unreconciled?
              • Change reconciled split?
              • Delete a transaction with reconciled splits?
          • Electronic reconciliation
          • Time for action – reconciling with a downloaded electronic statement
            • Reconciliation FAQ
            • Income and expense accounts
            • Balancing your cash account
          • Credit card reconciliation
          • Vital point to remember when importing an OFX file
          • Recovering from wrong selection of account
          • Time for action – changing the account to import into
          • Summary
          • Chapter 5: Repetitive Work? Let GnuCash do it
            • Let GnuCash worry about recurring transactions
            • Time for action – creating a recurring transaction from the register
            • A stitch in time saves nine
            • Time for action – triggering scheduled transactions
              • Is it Easter already?
              • Three different scenarios
              • Be cautious like an accountant
            • Tool to create many recurring transactions
            • Time for action – creating scheduled transactions in bulk
              • Schedule a transaction without knowing the amount
              • Scheduled Transactions FAQ
              • Create post dated transactions
            • Summary
            • Chapter 6: Business Mantra: Buy Now, Pay Later
              • Credit is the lubricant for the wheels of business
              • Billing terms and customers
              • Time for action – setting up billing terms and adding customers
              • Invoices and Accounts Receivable
              • Time for action – keeping track of credit sales
                • Invoice printing
                • Receivable Aging report
                • List of unpaid invoices
                • Unpost
              • Setting the starting invoice number
              • Time for action – setting the starting invoice number
              • Processing payment
              • Time for action – when the check is on hand
                • Partial payment
              • Bills and accounts payable
              • Time for action – keeping track of credit purchases
                • Due bills reminder
              • Summary
              • Chapter 7: Budget: Trip Planner for your Business
                • Budget
                • Time for action – creating a budget for your business
                  • Start with just three budgets
                    • Sales forecast
                    • Expense budget
                    • Cash flow projection
                    • Estimating based on previous period actuals
                  • Financial projections for investors and lenders
                    • Budget balance sheet
                    • Budget income statement
                  • Budget revision
                • Employees and payroll
                • Time for action – making payroll entries in GnuCash
                  • Net pay
                  • Liability accounts
                  • Calculation spreadsheet
                  • Split transaction map
                  • Payroll FAQ
                  • Employee and expense voucher
                • Depreciation
                • Time for action – making depreciation entries for assets
                • Owner's drawing
                • Time for action – entering owner's draw in your books
                • Summary
                • Chapter 8: Making Tax Times Less Stressful
                  • GnuCash currently supports only US business types for income tax
                  • Setting up income tax related accounts
                  • Time for action – mapping GnuCash accounts to tax schedules
                    • Pay your dues and demand services
                  • Creating income tax schedule report and TXF export
                  • Time for action – getting the numbers for tax returns
                    • Transferring data from GnuCash to Schedule C
                      • Cost of goods sold
                      • Car and truck expenses
                      • Depreciation
                      • Expenses for business use of home
                      • Other expenses
                    • Self employment tax
                    • Other taxes
                    • Manual entry or TXF import?
                  • Setting up sales tax tables
                  • Time for action – setting up sales tax tables
                    • Tax table
                    • Tax on tax
                  • Applying sales tax to invoices
                  • Time for action – charging sales tax on sales
                  • Summary
                  • Chapter 9: Printing Checks and Finding Transactions
                    • Finding transactions
                    • Time for action – searching for a transaction
                      • Sorting transactions
                      • Sorting transactions within a day
                      • Filtering transactions
                      • Viewing and sorting all transactions
                      • Find transactions FAQ
                      • Find customers, invoices, and so on
                    • Printing checks
                    • Time for action – printing checks
                      • Printing one check at a time on a 3 check sheet
                      • Printing address
                      • Printing multiple checks
                      • Custom check format
                      • Printing receipts
                    • Numbered accounts
                    • Time for action – assigning numbers to accounts
                      • Why account numbers?
                      • An example account numbering system
                      • Rectify over-invoicing
                      • Sales refunds
                      • Purchase refunds
                      • Check & Repair
                    • Financial calculator
                    • Time for action – calculating mortgage payments
                    • Summary
                    • Chapter 10: Adapting GnuCash for Non-profits and Personalizing
                      • No separate non-profit version of GnuCash
                      • Bookkeeping for non-profits
                      • Time for action – using GnuCash features for non-profits
                        • Donors and members
                      • Keeping funds for projects separately
                      • Time for action – allocating funds for projects
                      • Getting overall Income Statement
                      • Time for action – getting overall Income Statement
                        • Receivables
                        • Multiple sets of books
                        • Non-profit accounting FAQ
                      • Personalizing GnuCash
                      • Time for action – getting your work environment just right
                        • Other preference settings
                          • Set a color to each account tab
                          • Resize columns in the account register
                          • Leaving windows open
                          • Summary Bar and Status Bar
                      • Protecting your data
                      • Time for action – backing up your data
                        • Backing up
                        • Making use of auto save
                        • Retaining backup files
                        • Restoring from a backup file
                        • Password protection
                      • Summary
                      • Chapter 11: Data Import/Export: Use your Phone to enter Expenses
                        • Saving expense data in your smartphone and uploading to your PC
                        • Time for action – using a smartphone to save expense data
                        • Sending data through an expense tracking service
                        • Time for action – using an expense tracking service to get data into GnuCash
                          • Selecting an expense tracking service
                        • Migrating to GnuCash from other accounting software
                        • Time for action – migrating to GnuCash from other software
                          • Migrating data is not easy
                          • First consider a fresh start on GnuCash
                          • Business case for migration
                            • Migrating from Excel2 and OpenOffice.org4 Calc
                            • Migrating from Office Accounting2 (formerly Office SBA2)
                            • Migrating from Quicken Home & Business1
                            • Migrating from QuickBooks1
                          • Exporting FAQ
                          • Importing FAQ
                        • Exporting data from GnuCash
                        • Time for action – exporting data from GnuCash for migration and other purposes
                          • Migrating from GnuCash to other accounting software
                        • Summary
                        • Chapter 12: Application Integration and Other Advanced Topics
                          • These tutorials assume a certain level of proficiency
                          • Using OpenOffice.org Base to query data
                          • Time for action – using popular office software to query GnuCash data
                            • Which databases?
                          • Using MS Excel to create reports and charts
                          • Time for action – connecting from Excel to create reports and charts
                            • Other query and reporting tools
                          • Application integration
                          • Time for action – exporting contact information from GnuCash
                            • Export any data
                          • Foreign currency transactions
                          • Time for action – invoicing and receiving payment in
                          • Canadian dollars
                            • Credit card charged in foreign currency during overseas travel
                            • Foreign currency transactions FAQ
                          • Other handy tips and tricks
                            • Customer jobs and vendor jobs
                          • Time for action – grouping invoices for each contract separately
                            • Vendor jobs
                            • Special actions
                              • Voiding a transaction
                              • Adding a reversing transaction
                              • Year end closing
                            • Inventory management
                            • Mileage tracking
                          • Summary
                          • Appendix: Pop Quiz Answers
                            • Chapter 1: Getting Started with GnuCash
                              • Pop quiz – understanding accounts
                              • Pop quiz – understanding account types and hierarchies
                            • Chapter 2: Transactions – the Lifeblood of a Business
                              • Pop quiz – understanding transactions
                              • Pop quiz – navigating GnuCash
                              • Pop quiz – understanding transactions
                              • Pop quiz – using shortcuts to speed up bookkeeping
                              • Pop quiz – viewing the account register
                            • Chapter 3: Fun and eye-opening part - Reports and charts
                              • Pop quiz – viewing standard reports
                              • Pop quiz – customizing a report
                              • Pop quiz – creating stylesheets
                              • Pop quiz – saving exported reports
                            • Chapter 4: How not to get lost in the transactions jungle
                              • Pop quiz – reconciling with a bank statement
                              • Pop quiz – reconciling with an electronic statement
                              • Pop quiz – changing the account to import into
                            • Chapter 5: Repetitive work? Let GnuCash do it
                              • Pop quiz – creating a recurring transaction
                              • Pop quiz – triggering scheduled transactions
                              • Pop quiz – using the Scheduled Transaction Editor
                            • Chapter 6: Business Mantra: Buy Now, Pay Later
                              • Pop quiz – adding customers and creating invoices
                              • Pop quiz – choosing an account
                              • Pop quiz – keeping track of credit purchases
                            • Chapter 7: Budget: Trip Planner for your Business
                              • Pop quiz – creating a new budget
                            • Pop quiz – calculating payroll
                              • Pop quiz – charging depreciation on capital assets
                              • Pop quiz – setting up a Drawing account
                            • Chapter 8: Making Tax Times Less Stressful
                              • Pop quiz – filing tax returns
                              • Pop quiz – exporting income tax data
                              • Pop quiz – setting up tax tables
                              • Pop quiz – applying tax tables to invoices
                            • Chapter 9: Printing Checks and Finding Transactions
                              • Pop quiz – filtering transactions
                              • Pop quiz – printing date format in a check
                              • Pop quiz – editing account codes
                              • Pop quiz – calculating mortgage payment
                            • Chapter 10: Adapting GnuCash for Non-profits and Personalizing
                              • Pop quiz – creating a separate account for an event or a project
                              • Pop quiz – setting your preferences
                              • Pop quiz – creating a backup
                            • Chapter 11: Data Import/Export: Use your Phone to Enter Expenses
                              • Pop quiz – separating transactions by type of payment
                              • Pop quiz – importing a CSV file
                              • Pop quiz – format suitable for creating accounts
                              • Pop quiz – creating a Transaction Report with all of the transactions
                            • Chapter 12: Application Integration and Other Advanced Topics
                              • Pop quiz – GnuCash default data format
                              • Pop quiz – understanding GnuCash fields
                              • Pop quiz – contact info stored in GnuCash
                              • Pop quiz – entering exchange rate
                              • Pop quiz – finding all jobs

                            Ashok Ramachandran

                            Ashok Ramachandran is a graduate in Mechanical Engineering and has a Masters in Business Management from the Indian Institute of Technology (IIT) Madras. He started with an engineering career, including the running of two small businesses, and then made a mid-career switch to Information Technology (IT). Currently, he is a senior IT executive in the Washington DC area. His penchant for explaining technology to non-technical users and interest in writing culminated in this book. For other open source software suitable for small medium businesses, you can refer to his website http://smb-soft.com.
                            Sorry, we don't have any reviews for this title yet.

                            Submit Errata

                            Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                            Sample chapters

                            You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                            Frequently bought together

                            Gnucash 2.4 Small Business Accounting: Beginner's Guide +    Moodle 2.0 for Business Beginner's Guide =
                            50% Off
                            the second eBook
                            Price for both: $39.00

                            Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                            What you will learn from this book

                            • Handle routine transactions with ease, such as creating and processing customer invoices, vendor bills, and employee expense vouchers
                            • Use your bank and credit card statements to double-check your accounts by doing smart reconciliation
                            • Set up scheduled transactions to automate repetitive work and let GnuCash remind you when bills and payments are due
                            • Create a Trip Planner to reach your business goals using GnuCash budgets so that you can drive your business purposefully
                            • Make tax times less stressful by mapping GnuCash accounts to your income tax schedules
                            • Charge state, county, and local sales tax and print statements to send with payments
                            • Print regular and voucher checks, also with memos, to ensure proper credit as well as for professional appearance
                            • Extend the features of GnuCash to meet the special needs of non-profits
                            • Use your mobile phone to capture expenses on the go
                            • Migrate transaction data from other accounting applications
                            • Integrate with other applications to avoid redundant data entry causing frustration and errors
                            • Use canned reports, customize them, or create your own reports and charts using popular spreadsheet software

                            In Detail

                            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.

                            Get your accounts in order and avoid tax-day stress with this hands-on guide to GnuCash, the best free accounts software in the world

                            Approach

                            This book is a comprehensive beginner's guide that teaches you to use GnuCash from scratch with jargon-free step-by-step tutorials packed with tips. There are multiple choice questions to make learning more interesting and additional challenges thrown at the more adventurous user for a deep grasp of the topic.

                            Who this book is for

                            This book is written for you – the self-employed, the owner, partner or leader of micro-enterprises, home businesses, Small Office/Home Office (SOHO), and other small businesses – to help you maintain your books of accounts using GnuCash. This book is also for you – office-bearers of non-profits and students who want to learn accounting hands-on. If you are using a spreadsheet to maintain your business books and are wasting time, or you are handing over a shoe box of receipts to your high-priced accountant or are using another accounting application that is overkill for small business, get this book and download GnuCash.

                            Code Download and Errata
                            Packt Anytime, Anywhere
                            Register Books
                            Print Upgrades
                            eBook Downloads
                            Video Support
                            Contact Us
                            Awards Voting Nominations Previous Winners
                            Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                            Resources
                            Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software