Create The Journal and Journal Entry with Excel (Part 2)

In part 1, you have study how to create a current date and dropdown list of posting reference identifying the number of the account posted. Now we will study how to link Account Tittle  column with Posting Reference column. If you are beginner in excel, maybe you will need more times to practice this method.

Read More

Create The Journal and Journal Entry with Excel (Part 1)

A journal includes all accounting transactions and is considered the historical record for a business entity. All transactions must be recorded through a journal entry that provides specific instructions in a line-by-line sequence. In this post, I will show you How to create the Journal and journal entry with Excel. 

Read More

How to Label Your Account in Excel

In making financial reports, the first thing you should consider is how you manage your account groups. If you are wrong in a group set up an account, then in the making of general ledger or trial balance, you will have trouble. Grouping of accounts will accelerate and simplify the processing financial journal reports at any time.

In this post, I will introduce the basics of classifying and labeling an account with excel for beginners.

Read More