• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Check Register with Split Categories

G

garylundblad

Member
Does anyone know how to create an Excel check register that allows for transactions with split categories, like Quicken/QuickBooks allow for? For example, let's say that you want to enter a deposit that is made up of $50.00 for one category and $100.00 for another category. Is there a way to enter that transaction in a way that the total deposit shows up, making it easy to reconcile against a bank statement? The two dimensional aspect of a spreadsheet has always created a road-block for me at creating a good check register because of it's inability to handle split transactions effectively.

Any ideas would be greatly appreciated!

Gary
 
I'd suggest using a Primary Cost Code column and then columns for Secondary, Tertiary etc

Posting a sample file is recommended for more detailed advice
 
You must log in or register to reply here.
Back
Top