Microsoft Excel worksheets can consolidate your general ledger accounts into a trial balance worksheet for review during the closing process. When you need to review the current balances and verify ...

Many financial systems do a fine job of generating standard reports, but accountants often need more. In those cases, accountants can create custom solutions in Excel, but that approach has drawbacks.

Q. I manually maintain an accounts receivable aging report at our office because we use a simple cash-based accounting system that doesn’t offer such reporting. Is there a way to make this more ...

Though the practice of maintaining bookkeeping and ledger records dates back to ancient Mesopotamia, physical spreadsheet records have always suffered from the problem of requiring corrections and ...

Unless someone's calculator needs an upgrade, one plus one usually adds up to two. With Microsoft Excel, you can put that math to work when you input two separate columns of data into a single ...