Content provided in partnership with

Technology Industry

Setting up a double-entry bookkeeping system - AccPac Simply Accounting for Macintosh software program - Hassle-Free Bookkeeping - buyers guide - Tutorial

Home Office Computing, April, 1992 by Stephen L. Nelson

Setting up a double-entry bookkeeping system is more work than simply setting up a checkbook program. The basic reason is that double-entry bookkeeping systems do more than checkbook programs. For example, double-entry systems generate more forms and more-complex forms. They track more assets and more liabilities. And they more precisely estimate your profits (or losses) and your financial condition using accrual-based accounting techniques.

More Articles of Interest: Setting up a check-book system - using Microsoft Corp.'s Microsoft Money...; Keeping the books: how 5 businesses do it: to succeed, your operation...; SINGLE-ENTRY ACCOUNTING IN EARLY AMERICA: THE ACCOUNTS OF THE HASBROUCK FAMILY; double-entry bookkeeping method applied in Spain to account for transactions...; An overview of continuous data protection

Most Popular Articles in Technology: An overview of continuous data protection; Why all those current ratings?; Many countries now have a mobile penetration rate above 100%, report says; The Tata Group's big telecom gamble: VSNL's recent acquisition of Tyco ...; MEASURING BANK BRANCH EFFICIENCY USING DATA ENVELOPMENT ANALYSIS: MANAGERIAL ...; More »

However, you may not need all this extra horsepower; for instance, if your business doesn't have inventory and doesn't hire employees, you'll probably be able to get by with a checkbook program. But suppose you own and operate a thriving mail-order business, like our sample one, Krafts For Kids. Further suppose that Krafts For Kids sells high-quality children's toys and clothing. You need to manage not just the cash in your bank account but also your rather significant investments in customer accounts receivable and toy and clothing inventories. You'll also need to track the amounts you owe your suppliers (accounts payable), perhaps the wages paid to an employee or two, and maybe even the sales taxes owed the states into which you sell your goods. Finally, because the mail-order business is more complex than a service-based business, you will probably, also want to make more precisely estimates of profits and losses and of your financial condition.

The full-fledged double-entry bookkeeping systems like AccPac Simply Accounting all provide preconstructed charts of accounts, or listings of asset, liability, equity, revenue, and expense accounts.

Step 1--Perform a system test. The first thing you do after installing double-entry bookkeeping software is make sure it will actually do what you need it to do. This isn't as difficult as it sounds, however. Take half a dozen sample transactions--a customer invoice, an accounts-payable bill, an employee's payroll check, and so forth--and make sure you can use the installed software to process each sample transaction.

Step 2--Pick an easy conversion date. Once you're certain that the accounting software you've chosen will do the things it needs to do, pick a conversion date--the date you stop using your old system and start using your new system (you might even want to run both systems in parallel for six months or so).

There are several basic issues here. You want to pick a conversion date that makes sense in light of what's going on elsewhere in the business. For instance, if your busy season at Krafts For Kids is July, then July is probably a bad time to be fooling around with a system conversion. Also, you ought to pick a conversion date that makes it very easy to determine which transactions fall before the date and which fall after the date. If you chose a conversion date arbitrarily like, for example, April 23, you'll probably need to be especially careful that some transactions don't get recorded twice--once in the old system and once in the new system--and than others don't get recorded at all. Finally, you should make it as easy as possible to prepare annual and monthly profit-and-loss statements, which means that you'll usually want to convert at the end of the year or the end of the month.

Step 3--Load system tables. In most double-entry-based systems, you need to load a series of master files and tables. Usually, the first set of these has to do with systemwide issues. For example, in AccPac Simply Accounting, you need to name the company for which you will perform bookkeeping. You also need to define the fiscal year by telling the software when your accounting year starts and ends (usually January 1 through December 31). And you need to identify the conversion date. (See Figure 5.) You may also need to set up passwords and to define tables of applicable sales-tax rates.

In AccPac Simply Accounting, the commands for executing these tasks appear on the Setup menu. Other programs use similar menus with similarly titled commands.

Step 4--Load master files. Double-entry bookkeeping systems use master files to store information about customers, vendors, inventory items, and, if you're preparing a payroll, about employees. In essence, these master files do two things. First, they store information that's used repeatedly when processing transactions related to a customer or vendor, some inventory item, or a particular employee. Second, they summarize the year-to-date transactions related to a customer or vendor. For example, in the case of a customer master file, you'll enter information about each customer's name and address, telephone number, and so forth. (See Figure 6.) A vendor master file stores the same kinds of information about a vendor. An inventory master file stores product information about each of the things you buy, make, or sell such as its name, source, unit description, sales price, the cost, minimum inventory level, and the accounts for tracking the item's transactions. (See Figure 7.) And an employee master file stores each of the bits of information you use to prepare an employee's payroll check and any payroll tax forms, including the employee's name, Social Security number, income-tax filing status, and personal exemptions claimed.

Technology Industry

Setting up a double-entry bookkeeping system - AccPac Simply Accounting for Macintosh software program - Hassle-Free Bookkeeping - buyers guide - Tutorial

Home Office Computing, April, 1992 by Stephen L. Nelson

Find Research Guides for:

Find Featured Titles for: News

Most Popular Articles in Technology

Most Popular Publications in Technology