Skip to content
The Happy Finance Team

The Happy Finance Team

Help and ideas for busy numbers people

  • Home / About
  • Excel Training
    • Excel Training for Finance Teams
    • Bespoke Excel Training
    • Excel Training in Bristol
    • Excel Training Courses
  • Other services
    • Power Query Training
    • Finance Systems Review and Implementation
    • Part-time finance director
    • Financial Modelling and Excel Consultancy
  • Blog
  • Testimonials
  • Contact me
  • About Me
  • Privacy Policy

Tag: charity accounting

Posted on 9th October 20239th October 2023

Monthly irrecoverable VAT adjustments with Xero and Power Query: Part 2

This blog post probably won’t make a lot of sense unless you read Part 1 first.

Having customised our VAT report in Xero in part 1, we’re now going to use Power Query to turn this into a journal.

Continue reading “Monthly irrecoverable VAT adjustments with Xero and Power Query: Part 2”
Posted on 20th September 202320th September 2023

Monthly irrecoverable VAT adjustments with Xero and Power Query: Part 1.

I asked on LinkedIn the other day whether people would be interested in my method for posting monthly irrecoverable VAT adjustments and was pleasantly surprised by the responses.

So here goes.

Continue reading “Monthly irrecoverable VAT adjustments with Xero and Power Query: Part 1.”
Sign up to my quarterly newsletter

Recent blog posts

  • Should I learn Power Query or Power BI?
  • How to conditionally format a bar chart in Excel
  • Structuring data in spreadsheets – for humans and computers
  • Excel consultancy – what is it?
  • Does Groupby replace pivot tables?

View blog posts by topic:

  • Business planning and strategy
  • Carbon Accounting, Impact Reporting and other green stuff
  • Cashflow
  • Excel and beyond
    • Excel
    • Financial Modelling
    • Googlesheets
    • Power Query
  • Finance team management, training and development
  • Interim finance work
  • Machine Learning
  • Mental Health in the workplace
  • Miscellaneous
  • Planning, Analysis and Reporting
  • Process Improvement and Internal Controls
  • Systems implementation
  • VAT and other taxes
  • Xero

Useful links

  • Leila Gharani – You Tube
  • Chandoo – Excel, Power BI and wacky charts
  • Excel Off the Grid: videos and blogs about Excel, Power Query and automation
  • Accountingweb
  • ICAEW – Excel community
  • Excel University Blog
  • Goodly (Chandeep Chhabra) – Power Query resources
  • Excel Moments (Victor Momoh)
  • My Online Training Hub (Mynda & Phil Treacy)
  • Excel Guru – Excel, Power BI and Monkey Tools
  • ExcelJet
  • Oz du Soleil – Excel on Fire – YouTube

View blog posts by topic

  • Business planning and strategy
  • Carbon Accounting, Impact Reporting and other green stuff
  • Cashflow
  • Excel
  • Excel and beyond
  • Finance team management, training and development
  • Financial Modelling
  • Googlesheets
  • Interim finance work
  • Machine Learning
  • Mental Health in the workplace
  • Miscellaneous
  • Planning, Analysis and Reporting
  • Power Query
  • Process Improvement and Internal Controls
  • Systems implementation
  • VAT and other taxes
  • Xero

Techy stuff

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy Policy Proudly powered by WordPress