How Do I Create An Invoice?

Profitworks Free Accounting Software In Excel

To download the full manual click here.

To download the software click here.

What You Need To Do In Summary

To create an invoice you simply need to create an invoice using any excel based invoice template you want to use. You can find a number of free invoice templates online. You can also download our invoice template by clicking here. 

How To Enter The Invoice Transaction In The General Ledger

1. Go to the worksheet labelled “General Ledger”
2. Enter the Year in column A for each part of the transaction.
3. Enter the number of the Month for each part of the transaction in column B
4. Enter the number of the Day for each part of the transaction in column C
5. Enter the invoice number for the transaction following the format #####-##### in column D, ensure the first five digits of the invoice number is the customer number for the customer you are invoicing
6. Enter the division number for each part of the transaction in column E
7. Enter the customer number for this transaction in column F. If this transaction is not related to a specific customer
enter 0.
8. Enter the account number for each part of the transaction in column G
9. Enter the payee for each part of the transaction in column H
10. Type in a description for each part of the transaction in column I
11. Enter the amount for each part of the transaction in column J. Enter debits as positive numbers and credits as
negative numbers
12. Columns J and K will automatically populate based on the information keyed into column F
13. Double check once you are done entering all parts of the transaction that cell H3 still equals zero. This means your
general ledger is balanced. If cell H3 does not equal zero that means you have made a mistake with one of the
amounts you have keyed in

Note: There is no need to enter your transactions in order of the day they occurred. The system allows you to enter a
transaction from an earlier date after a transaction from a later date. There is no need to enter transactions in the order in which they occur.

Balancing Your Transaction And The General Ledger

As noted in the “Entering a Financial Transaction In The General Ledger” section cell H3 should always equal zero. As long
as you check that this cell always equals zero after every transaction or transaction correction, you will always have a
balanced ledger.

How To Track The Payment Of The Invoice

To see how to track the payment of the invoice click here. 

To download the full manual click here.