Trying to work out cash in hand balance from directors loan account?

[adnw]

hi

Im looking for a way to sort of work out the following:

Im using a ltd company quickfile account.

a seperate petty cash account, or cash account was not used in quickfile.

the company bank account was originally funded by a bank transfer from a personal account.

this was then tagged to the directors loan account.

purchase invoices were paid using various methods.

some were with the company bank account,

some were cash - which got tagged to the directors loan account,

some were personal card - which got tagged to the directors loan account,

sales invoices

a high percentage were paid in cash - this was then tagged to the directors loan account.

a small percentage were paid via bank transfer into the company bank account.

everything tallies as it should do and there are no mistakes.

but, is there a way to get a figure of how much physical cash should have been taken out of the directors loan account and should be effectively sat there as actual cash (assuming it then hadnt been used for non related personal items).

i assume i should have probably had seprate accounts in quickfile showing a cash account, then tagged trasnfers from directors loan into and out of that. i didnt do this though…

y way

[QFSteve]

Hello @adnw

You could export data from the directors loan account.

Reports > Chart of accounts > Select a directors loan account
You can filter by date range if required
Select Export data (Selected Items or All ledger items for a date range)

This will give you an excel report with 4 columns (Code/Name/Credit/Debit)

Hope this helps

[adnw]

hi
i dont think that will allow me to do a Cash in VS Cash Out will it?

i cant figure out how to work out what cash on hand balance should be, rather than going right back to the beginning, untagging everything, then re tagging it all to a cash account?

[QFSteve]

Hello @adnw

It would show money in and money out of the account (Debits vs Credits).

Going forward I would do all cash transactions via a cash bank account to separate them easier.

[adnw]

yes will do in future thanks.
i understand i can get money in money out, im looking to do it for cash only though