This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I created a check register in Excel and I'm looking for a way to enable split transaction entries. Does anyone know have a formula or some other solution would work for this?
For example, in the transaction below I want to split the $100 ATM Withdrawal transaction to show multiple expense categories (i.e $20 gas, $50 groceries, $30 entertainment).
| Date | Transaction # | Payee | Category | Deposit | Withdrawal | Balance | Cleared | Comment |
|---|---|---|---|---|---|---|---|---|
| 9/24/2018 | 123456789 | Cash | ATM Withdrawal | 100.00 | XXXX.XX |
Thanks for your help!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
There is no built in way to do that. There are several templates that claim to offer the ability, but I've never used any of them. If you use a search engine, you'll find some.