Balancing Accounts Receivable Daily Spreadsheet example

Reconciliations Cash / A/R & Deposits - May, 20xx
			* & ***		**		****
MAY	Beginning Bal	Sales Batch #	Sales, Adjustments & Fin. Chrg.	Cash Batch #	Total Change To A/R	Ending Bal	Display Total A/R	Total Amount Received	Checks & Cash	Credit Card
5/1/20xx	$ 200,745.17					$ 200,745.17
5/1/20xx		* 313	$ 7,456.32	** 314	$ 10,956.96	$ 197,244.53		$ 10,956.96	$ 6,125.23	$ 4,831.73
5/1/20xx				315	$ 21,971.37	$ 175,273.16	$ 175,273.16	$ 22,571.37	$ 18,549.32	$ 4,022.05
5/5/20xx		316	$ 16,742.39	317	$ 484.57	$ 191,530.98	$ 191,530.98	$ 484.57	$ 484.57	$ -
5/8/20xx				318	$ 10,789.65	$ 180,741.33	$ 180,741.33	$ 10,789.65	$ 8,789.65	$ 2,000.00
5/9/20xx		319	$ 5,236.78	320	$ 62,774.37	$ 123,203.74		$ 63,774.37	$ 57,642.98	$ 6,131.39
5/9/20xx				321	$ 1,280.29	$ 121,923.45	$ 121,923.45	$ 1,280.29	$ 1,280.29	$ -
5/12/20xx		322	$ 8,792.35	323	$ 3,245.75	$ 127,470.05	$ 127,470.05	$ 3,245.75	$ 2,157.65	$ 1,088.10
5/13/20xx		324	$ 17,324.75	325	$ 756.23	$ 144,038.57		$ 756.23	$ 756.23	$ -
5/13/20xx				326	$ 35,987.35	$ 108,051.22	$ 108,051.22	$ 36,426.15	$ 30,876.84	$ 5,549.31
5/18/20xx		327	$ 7,423.10	328	$ 4,684.50	$ 110,789.82	$ 110,789.82	$ 4,684.50	$ 4,684.50	$ -
5/19/20xx		329	$ 6,219.78	330	$ 98.32	$ 116,911.28	$ 116,911.28	$ 98.32	$ -	$ 98.32
5/21/20xx		331	$ 6,055.52	332	$ 240.42	$ 122,726.38	$ 122,726.38	$ 240.42	$ 240.42	$ -
5/22/20xx		333	$ 12,575.10	334	$ 17.52	$ 135,283.96	$ 134,283.96	$ 17.52	$ -	$ 17.52
5/24/20xx		335	$ 13,344.66	336	$ 300.45	$ 148,328.17	$ 148,328.17	$ 300.45	$ 300.45	$ -
5/27/20xx				337	$ 39,789.24	$ 108,538.93		$ 38,789.24	$ 33,944.22	$ 4,845.02
5/27/20xx		338	$ 17,799.35	339	$ 21.45	$ 126,316.83	$ 126,316.83	$ 121.45	$ -	$ 121.45
5/31/20xx		340	$ 18,897.59	341	$ 775.20	$ 144,439.22	$ 144,439.22	$ 775.20	$ 775.20	$ -
5/31/20xx		*** 342	$ 75.32			$ 144,514.54	$ 144,514.54
			$ 137,943.01		$ 194,173.64				$ 166,607.55

* "Total Invoice" amount from Sales & Finance Charge Posting registers
and "TOTAL NET SALES (From Sales History)" from A/R to G/L Interface
** "TOTAL CHANGE to AR" on the Cash Posting register & "TOTAL CASH + DISC ALLOWED" on A/R to G/L Interface
*** Finance Charge
**** "Total Value" from Display Total A/R Open & "Cutoff Grand Total" on A/R Aged trial balance;
Optional: Column I is the "Total Amount Received" on the Cash Posting register
Optional: Column J --"Checks & Cash" -- is the actual bank deposits
Optional: Column K --"Credit Card"-- is the actual credit card summary.