Importing into Excel Once this Print to File option has been created, you can print the general ledger to this printer option from your accounting system and import the resulting .prn file into Excel.

Using Excel as a General Ledger It's important to note that every business is different from one another and will, therefore, have different reporting needs. The first step in setting up a ...

General Ledger Basics. The accounting process is over 500 years old. Modern accounting differs very little from that begun by Luca Bartolomeo de Pacioli, mathematician and father of modern ...

Once you've calculated all of the balances from your various general ledgers, use those numbers to begin creating your trial balance sheet entries in Excel. Your general ledger balances may be ...

Excel has all of the tools needed to create and maintain a general ledger, but it requires a solid understanding of basic accounting and attention to detail. For business owners who do not have ...