journal entries

  1. E

    Power Query to automate payroll entry

    I am a fractional CFO who is familiar with Power Query and its capabilities but have not been able to apply it in practice. One opportunity I see for PQ is to automate a monthly payroll entry I have to make to "close the books" for multiple clients. The client has many departments and close to...
  2. G

    Help, Need Macro to reverse accruals in template

    Hello, I would like a Macro that will look for "A" next to a journal entry and copy the items to a new worksheet within the same workbook and transpose the account numbers & Item descriptions vertically.Any help would be greatly appreciated! Thank you! This is how the template looks...
  3. J

    Using Marcos to create financial statements from journal entries.

    I'm completely new with macros. I was wondering what you would need so that the information will automatically update itself onto a summary page. For example for entries on one worksheet to create a statement on another worksheet? Example: <tbody> Asset Type Description Date Amount OA Bonds...

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