Custom report: employee advance

1

Advance 1
Advance 12842Ă—1302 151 KB

Advance 2
Advance 21920Ă—1080 108 KB

image
image1850Ă—791 47.5 KB

As shown above, I wanted to get a report that show advances received against the salary by each employee. Can someone please tell me how should I get it?
I feel this is possible if we can select employee name from the list in a way similar to customer/ supplier, at payment voucher point. As this kind of advances happen daily basis in construction industry for contract laborers and number is high even though the business is an SME, it is critical for the recovery or netting of at pay slip level specially when manual lists can be misused.
Kindly note my question is not about recovery process. It’s about getting system generated report to see how well pay slip generation and salary advance payments can be delegated to two different parties.

2

You need to show the custom report definition used to generate these reports.

1 Like
3

image
image1822Ă—903 78.5 KB

4

You are correct, but you cannot, because Employee is not currently a category of payee. So you can enter an employee only as Other. As a result, your payments of advances do not affect any employee subsidiary ledger. The 3,000.00 debit you see on your report is not associated with any employee. It is the debit that balances the 3,000.00 credit from money leaving the cash account.

The 1,000.00 credit shown on your report is unrelated to anything else you have shown. So I cannot tell you where that came from.

1 Like
5

Thanks.
My suggestion is is there anyway we can make Employee a category of payee? If this is a possibility, this gives a very smart solution to industries using labor intensive activities.

1000 is coming there as a result of assigning an pay slip deduction item.

1 Like
6

An employee category has been promised by the developer. But it is not a trivial development. Customers and suppliers took more than three years, and every business needs those. Not all businesses make payments to employees.

1 Like
7

Thanks a lot. I can understand that its a challenging task. However, it will be a real value addition for Manager…I am exploring an option to meet a request coming from a business owner using QB so far to consider switching to another software…due to various limitation in QB.

1 Like
8

@ATMCAssociates try modifying your custom report as follows:

  • Under the Select… section, change the line Employee / Name to Date;
  • In the Group by… section, select Employee / Name;
  • Do Not check Groups to collapse.

If the report is useful, please post a screenshot of it.

1 Like
9

Thanks a lot for the kind help. This brings in rows which has only date. Hope I did what you intended. Thanks you.