Keep it simple, maybe use this format in excel :-
| Date |
Document no. |
External document no. |
Debit |
Credit |
| |
|
|
|
|
| |
|
|
|
|
Document no. is the number generated by ur ERP, for e.g payment voucher will be debited and Invoice will be credited.
External document no. is the invoice or bill no. from vendor.