Home > Forum Home > Analyzing Corporate Financial Data > Receipts and Payments journal Share

Receipts and Payments journal

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

Forum TopicPost Reply Login

Receipts And Payments Journal

Rate this:
(3/5 from 1 vote)
ConfusedIf 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 on
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
ApplaudIf 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 on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Receipts and Payments journal in the