trial balance

  1. B

    Rolling Balances with Beginning Trial Balance

    Hi, I work as an accountant and am attempting to use financial data to create rolling balances. I have two Fact tables connected with various Dim tables. The first Fact table contains trial balance data at a given point in time i.e. end of month. The second table contains transaction data...
    • bkjohn2016
    • Thread
    • accounting rolling balance rolling calculations rolling data trial balance
    • Replies: 3
    • Forum: Power Tools
  2. F

    Consolidate / compare trial balances based on their codes?

    Hello everyone, I was wondering whether it is possible to consolidate and / or compare two different trial balances in Excel without the use of macros that are out of my league to edit for future use if too complex. For those who do not know, a trial balance follows an arithmetic logic...
  3. E

    Excel Macro for my Two complicated life

    Hi! I have SHEET1 like this: And SHEET2 like this: So basically what I want to do is to automatically post SHEET2 entries to SHEET1. The amounts on "SHEET2 column D & E" will link to "SHEET 1 Column D & E". If you notice, "Petty Cash" have 2 adjusting entries, so I need to insert a...
  4. T

    Matching two columns to sum their corresponding cells

    Hello, I have text data in column A and the corresponding Numeric(the debits) in column B. Also have text data in column C, and it's corresponding numeric (the credits) I'm column D. The data in Col C have more than one corresponding entry to Col A at times. How do I get Col A to match its...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top