My staff uses the accounting report to record net activity in a daily basis. The entry obviously includes tips payable (we don't cash out credit card tips every day, but rather include them in payroll). Additionally, starting in November, DoorDash withholds on a daily basis the delivery fees and the related tips. There seems to be no way to net those charges out of either the credit card settlement that I'll be receiving or to reduce the tips payable by the amount that DD has withheld. There also doesn't seem to be anyway of segregating DD tips from all other server tips. Consequently, what had been a pretty mindless action of entering a JE from the accounting report has turned into a research project for each day and takes an unacceptable amount of time for my staff to do.
Has anyone figured out how to configure the accounting journal entry activity to reflect (a) the reduction in credit card settlement because of DD fees and tips and (b) offset the tips payable by the amount of DD tips?
