I rent a place from my client. So, end of the month. I need to give him a balance statement.
As the customer and supplier are not linked we have to take statements from payable and receivable and send it.
You will need to create this person as a supplier and then as a customer.
If this person as a customer owes you $5,000 and you owe this person as a supplier $3,000, what you want to do is to offset $3,000 from both amounts so you don’t owe anything while they still owe you $2,000.
You can enter this non-cash offset transaction as a journal entry where you record it as:
Account: Customer credits, credit $3,000
Account: Supplier credits, debit $3,000
Maybe in future it will be possible to link related customer & supplier accounts so these entries would be done automatically.
Thanks didn’t get this very well, am not an accountant
having a button on customer/Vendor to highlight him as Vendor/Customer, is the best way, so all his transaction will be in one location once select to view customer/Vendor Statement of account
@Ayman, what you are suggesting is likely to lead to problems, particularly for users of Manager without a lot of accounting knowledge. Customers mostly affect receivables. Suppliers mostly affect payables. Mixing the two is almost certain to lead to many mistakes. My guess is that across all Manager users and all their customers, the situation where a supplier is also a customer will be fairly rare. Of course, that is just my opinion.
e.g Say you have same Customer & Supplier name ABC Ltd. Create both name in customer as well as in supplier.
Step 2. Create Bank or Cash account called “Contra A/C”
Step 3. Process sales and purchases as normal for ABC Ltd.
Step 4. Pay and receive through contra a/c. Say your Sales is $500 and purchase is $1000.
Step 5. Receive $500 to contra a/c and Pay $500 through contra a/c.
Now you will see that customer bal is 0 contra a/c bal is 0 and you still owe $500 to your supplier.
why complicate things when Manager already has Journal Entries? a journal entry would do exactly the same thing without any unnecessary transactions appearing in your Customer or Supplier statement.
your suggestion makes two transaction entries whereas it can be done easily with a single journal entry.