Introductory Accounting

CHAPTER22

More Spreadsheet Tools and Techniques

In This Chapter

• Using spreadsheet templates
• Building a budget template
• Developing a shadow accounting system
• Filtering and analyzing data
• Creating supporting schedules

No matter what accounting software you choose, you’re always going to bump into limitations when it comes to analyzing data or tracking additional information your accounting software can’t manage. For instance, in Chapter 14, we discuss a supporting schedule for prepaid expenses. Your accounting software requires you to lump all prepaid expenses into a single bucket, but you’ll want to maintain a listing of the amortization rate ...