Well I separate it when I used excel’s autofill cell features it will made the last numeric numbers sequential just by pulling it down to other cells. from 1,2,3,4 instead copy cells 1,1,1,1. when I want to batch update.
I rather have parallel reference one for manager since it mixed with cash accounts it became useful as integrity check.
Another defined myself to associate with external document. for reference point by line items. Noted bank transfer (Maybank) does not have any its own reference number by line items shown in bank statement. which made checking between manager and bank statement difficult by auditors. If i used auto numbering than there will be non sequential numbers in reference within bank account tab. @raj had made the point that there is the need to distinguish transaction for cash and bank. my solution would be add own reference to know which is which.
I appreaciate that you have made it easy by allowing the bank account and cash account custom field to be display in transactions respectively, that made the identification easy. except by line items to associate with external documents.
Description may described by my client for their understanding base on actual documents. I would not want mixed it up with mine so I’ve use custom field more often.
For example, the client of mine is purely marketing person, she is the director, certain period she will transfer the money to her own personal designated bank accounts for certain usage is like piggy bank, where you save money to buy phone, or other piggy bank for tuition fee. end of financial period then she will transfer balances (if yet to be used) back to company bank accounts. she called it profit first.
what do we accountant called it? Loan to director.