so we will have Date, Reference, pay to, to the order of, then cheque number.

What do you guys think?

With the budget and knowledge we have it took's a lot for us to create this but we will do that. Your further guideline we boost us more, such as which tables to work with and so on.

There is huge scope for misuse of FA for money laundering and embezzlement besides hiding transactions amidst legitimate ones making forensics that much more difficult if what you say is allowed since there is no info on the final resting place for the monies to all the intermediate parties concerned.

I and our team worked on FA very much, we really believed in we are a part of FA and can't give up.

We found a normal solution for check issues. We just need to know the encashment period while looking at "Bank Account Inquiry". For this we need to:

1. Add a date input in customers and suppliers "Payment Entry" for keeping check encashment date.
2. Altering “Bank Account Inquiry” section. Add a Combo box to let users to choose wither they are looking entry date or encashment date and have another encashment field in data grid.

Apmuthu, in your experience how much time does it takes to alter FA to feet in this shape?

Sorry, FA does not cater to this, though you may put in whatever you want in the memo field and hope the cheques you issue of take in are their final resting place - you will not be informed by your vendors that they have passed on your cheque to their vendors.... and you in your turn will not inform your customers that their cheques have been passed on to your vendors!

Furthermore, your bank statement may not have much written in it's description field for you to reconcile multiple cheques with same value and date....

Endorsing someone's cheques to another is generally infrequent and is accomodated using Journal transfer entries but in your case it seems to be the order of the day!

Good Luck.

In “Reconcile Bank Account” you can just checkmark and compare with bank statement and this do not alter or change GL. Any change should made at other part like GL or payment entry manually.
Now if that business want to look up for checks they have taken from date to date for encashment or giving to other suppliers what have to do?
For your consideration our type of accounting is accrual and not cash accounting and because of that most of bank transaction based on check.

The actual date of encashment taken from the banker's statement can be entered into the bank reconciliation page at Banking and General Ledger => Reconcile Bank Account.

How do you put "Bank Account Reconciliation" in check section?

1. Adding another "date" input in "Payment Entry(ies)".
2. For checks look up solution, to add 2 "Date input text" in "Journal Inquiry" with start and end date; this will solve everything because we can easily check what checks should be cashed at specific period of time or when is the checks due dates.

We worked a lot with our teams, hence we found another solution to simplify it. Here is the solution we found:

1. Adding another "date" input in "Payment Entry(ies)", also as you mentioned we can add, other check information in "Memo" section.

2. Now, for checks look up solution, if we add 2 "Date input text" in "Journal Inquiry" with start and end date this will solve everything because there is a nice "Memo" search option that helps a lot to find check number or anything else.

Please give us a applicable solution