DESKTOP EDITION CLOUD EDITION SERVER EDITION GUIDES FORUM

Improvement to payment and receipt forms


#1

It would be very helpful if the cash payment and receipt forms were improved to include several features:

  • Linkage to customer/supplier subaccounts. Established customers don’t always buy on credit, making a sales invoice unnecessary. Likewise, businesses often pay cash to established suppliers, so purchase invoices are not needed. This linkage would eliminate separate invoice and spend/receive transactions. And it would allow the complete history of a customer/supplier in a statement, not just the history for credit sales/purchases. Obviously, the entry process would need to include a method for distinguishing random cash customer/suppliers from those with the same names defined under the Customers and Suppliers tabs.

  • Address fields for payers/payees. These would be optional for occasional payers/payees, but would prefill for defined customers/suppliers.


Cash Sale to be recorded under your customers
Accounts Payable or Expenses
Sales receipt
Report by supplier/customer on cash basis
Account receivable issue
Idea - adding 'paid' option to sale/purchase invoice
#2

Yes Please! :sweat_smile:


#3

Tut, receiving income money from (invoiced) Customers in advance/excess of the amount invoiced seems to be recorded as:
Dr Cash at bank xxx
Cr Accounts Receivable xxx [both Balance Sheet accounts]

Two Questions for you please:

  1. In Accrual Accounting system: Why isn’t the overpayment/excess recorded as a Credit to ‘Income in Advance’ Liability and also offset against Customers?

  2. When the P&L Statement is reported on a CASH basis, the money received from customers paying in advance (eg Subscriptions not yet invoiced) should be included as Income of that period but Manager does not. The Cash-basis P&L Statement is therefore not correct and misleading to users and we cannot reconcile monies received in CASH-Based P&L Stmt against Cheque Account without manually adding the Credit balance in Accounts Receivable. Very messy and novice users would have no idea how to do this.


#4

In double-entry accounting, the sum of debits must equal the sum of credits. You are correct that the excess or advance is debited to the cash account. Cash accounts are assets and are increased by debits. So the account balance goes up to match what happens at the bank: you have more money. The offsetting credit goes to Accounts receivable as a contra entry, that is, as an entry reversed from what normally goes into the account.

It would also be correct to instead credit a liability account named something like Customer credits. Some people like that approach better. In fact, until about a year ago, that’s what Manager did. But things were simplified so all transactions could go to a single customer subaccount and be processed the same way. By coincidence, there is another post on this subject on the forum today: Handling Advance Payments Better.

But what cannot happen is to do both as you suggest. That would result in an unbalanced entry.

That’s one of the shortcomings of cash basis accounting. If you are taking deposits, you need an income account for them. If you later earn the money, you would need to transfer to Accounts receivable by journal entry to pay off a sales invoice. At its core, Manager is an accrual basis accounting system, with optional cash basis reporting. But if you are going to use it that way, you need to set it up that way. In the end, it’s more work. That’s one reason most accountants dislike cash basis accounting.

In its regular operation, Manager does not show Accounts receivable under cash basis accounting. But if there are negative balances (customers have overpaid or made deposits), it will be shown. This is really a reminder that you are not accounting correctly for things with the choice you have made on basis.


#5

hi Tut,

yes, I agree with you about cash accounting and I understand your explanation. Thanks so much.
I think I will use accruals so that monies received in advance are reported in the P&L as Income and in the B/S as Liability. But, if the Customers are assigned to use the Accounts Receivable control account, the credit balance will show as a negative. I can cope with this and explain to clients.

Thanks Tut, you have convinced me to revert to Accruals!!


#6

this is a MUST HAVE, i was deluded when i saw that i cant use cash sales for existing consumers.
invoice and spend/receive is not time efficient.
Please try to implement it as soon as possible


#7

100% agree it is MUST HAVE.


#8

Same opinion…


#9

Yes, these improvements would be excellent. Looking forward to their implementation.


#10

I would also welcome these improvements.