Resource Logic Client/Server Development Services

Notes on Daily Reports

Daily Reports are used to record retail outlets cash receipts, checks, and credit card transactions and make up deposit slips for the daily deposit.

This page is written in JavaScript. It does not save anything to a database, although a real world user would. This is a very simplified example. A production version of this program would itemize checks, credit card receipts, and petty cash disbursements, and list each of those on the deposit slip. Most businesses would also include a labor summary and sales taxes due.

Select an outlet (out of four available). Enter numbers for beginning petty cash balance (the amount in the register), Cash Receipts, Checks, Credit Cards, Petty Cash Disbursements, and the Deposit Slip amount. The remaining fields are computed automatically. As an option, leave the Disbursements field blank.

Once all these values are entered, click on the Post command button. The text area at the bottom of the screen will contain from two to four journal entry lines. The 101.xxx account is the bank account and the 401.xxx is the sales account. These are always present. The 100.xxx account is only modified if the ending Petty Cash balance is different from the beginning Petty Cash balance. The 635.xxx account is only present if there is a petty cash disbursement.

The S field is a subtotal marker. The column of dollar amounts should sum to zero.

Highlight everything in the text area and copy it to the clipboard. Then launch your favorite spreadsheet, and paste the contents of the clipboard into a blank worksheet. The fields are each pasted into separate cells, since they are separated by tab characters. With further programming work, this information could also be appended to a transaction table in a database.

Your browser must be Javascript enabled. Netscape and Internet Explorer versions preceeding Version 4 do not support Javascript.


For further questions, please eMail us at Info@ResourceLogic.Net