Receipts and Payments journal

Excel Help for Receipts And Payments Journal in Analyzing Corporate Financial Data

Receipts And Payments Journal

Rate this: (3/5 from 1 vote)

	If i have a worksheet that contains Receipts and Payment Journal for a small business and i have other worksheets for the individual accounts represented in the Journal, how can i get the individual accounts to be updated as entries are made in the Receipts and Payment Journal?
	Posted by Starliner on 29 Jan 2011

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Account identifier with conditional formulas Rate this: (3/5 from 1 vote) If you enter an identifier related to the Account for each payment or receipt then this can be used to update the sheet with the individual account.  This can be accomplished with conditional formulas such as SUMIF, COUNTIF etc.
	Excel Business Forums Administrator
	Posted by Excel Helper on 29 Jan 2011

Displaying page 1 of 1