For months I have been struggling with ho to enter invoices as required by the tax office.
I receive an amount for a purchase from a portal (multiple). I will call this X. I then have to invoice part of this amount to our customer (Y) (who is not the one paying) and pay the customer the difference called Z (X - Y = Z) (possible additional amounts to be subtracted from the payment to the customer).
What I want is this:
1. Money received from a portal: X DB 572 bank, CR 561 (intermediary account like a clearing account)
2. Invoice to customer: Y CR 751 Sales, which is automatically (be ZOHO default) put as DB on Accounts Receiveables, but I would prefer to DB on the 561.
3. Payment of Z (X-Y) to our customer: Z CR 572 bank and DB 561
4. Gross profit: X-Z DB 561 and CR 705 Commissions earned
The balance of these bookings of on sale on the 561 would then be 0, but because of the defaults I have two 561 accounts (Accounts Receivable (default for Invoice) and a manually created account 561 Deposits or even three if I didn't enter some transactions with a Journal entry (accounts payable).
What would be the most efficient way to have just one account 561 as clearing account, , where invoices (Y), money paid (X-Y) and money received (X). A Clearing account in ZOHO does not allow for certain entries and other account types only allow for only DB or CR (not both). Unfortunately this is what is required by our tax office, so I have to create this account manually based on the two (or three) other accounts as described above.
Have I explained the situation sufficiently otherwise do not hesitate to ask.
Kind regards
Brian