Tag: Reporting

How to make a video in PowerPoint

Jeff PospisilLeave a comment

I’m an accountant that makes videos on the side. I have very limited skills in the area of video editing, and I don’t want to spend the time to learn fancy new tools. Prior to PowerPoint, I would make about 3-4 videos per year. I didn’t mind the creating part, but the video editing was intimidating.

Since I learned I could just turn my PowerPoint into a video, I make 4-6 videos a month! No more editing! Everything is finished in the creating and recording process. Once I’m happy with the recording, you just click export. Plus, it seems like every other month I learn something new…almost like Microsoft had video-making accountants in mind when they update PowerPoint.

In this video, you are going to see a recording of me making this video. Behind the scenes-ish.

Useful Links

Noncash Donations: How do I receipt that?

Jeff PospisilLeave a comment

I’ve worked in church finances for almost 20 years now. Almost every time I receive a noncash donation (such as stock or a piano or grain), the donor wants a receipt and often they want you to include on that receipt the value of the donation. The church is not equipped to value noncash gifts which amount to providing tax advice. The IRS recognizes this and warns donees to not value these gifts.

So what do you do if the donor insists on you valuing the gift? Here’s what I do. I normally visit with the donor and let them know that the IRS doesn’t allow the church to give an amount for the value of a noncash gift. I let them know that we’ll give them a receipt that has all the details they need for any tax professional to figure out the value. In the video I detail how to fill out the receipt, and I have a template linked below.

Check out the video below:

Useful Links

Giving Statements Tips and Best Practices

Jeff PospisilLeave a comment

How does your church leadership view Giving Statements? Many think of it as a tool to guilt people into faithful giving. Some of it view it just as an administrative task that does nothing for the church. What if your church’s giving statements were something that people looked forward to receiving and helped the grow as generous givers? I think this is possible, but it starts with changing your view of the giving statements.

Here’s the changes to be made:

  • From a reminder of pledges to a reminder of how giving is changes lives/the world.
  • From the focus being on the IRS and the Church Budget to the focus being on the donor and the Church Mission.
  • From an administrative burden to a ministry opportunity.
  • From something that the donor should be grateful to receive to a way to show gratitude to the donor.

Check out the video below:

Useful Links

Should Pastors know what people are giving?

Jeff Pospisil1 Comment

Why would a pastor want to see the giving records for a church? Generally speaking, your pastor DOES NOT want to see the giving records, but they believe they need to see the giving records to lead well. Very few pastors that I’ve met want to see the giving records out of curiosity or to schmooze the big donors. The topic of money makes the uncomfortable and they don’t want to be seen in the same light as Kenneth Copeland.

Unless your pastor has proven themselves untrustworthy with sensitive information, chances are knowing how people give will help them lead better. They’ll know which members are all talk verses those that are fully invested in the mission of the church. They’ll be better able to care for their people if there is a change in giving.

Check out the video below:

Useful Links

Making your Excel Reports Prettier

Jeff PospisilLeave a comment

The sad truth is that often looks do matter. You might have a wonderfully accurate report with plenty of meaningful insights in it, but sometimes the formatting, or lack there of, can cause people to miss those insights or even dismiss your report. Why is that? For numbers people, usually their eyes are searching for those insights. They are looking for meaning in the numbers. For everyone else, they need help in knowing where to look. Formatting can do that. They also have a lack of trust in numbers and a more professional look can help them trust more. I know this doesn’t make sense to a numbers person, but that’s life.

There’s nothing fancy in this video. Just some basic formatting and page layout tips. I go through it pretty quick because it is quick and easy. In five minutes, you can easily transform a report from plain to…more or less professional.

Useful Links

Closing a month or year in QuickBooks Online

Jeff PospisilLeave a comment

One of the things I take pride in is keeping accurate accounting records and reporting anything that’s out of the ordinary. Something that undermines this is when I accidentally post something to a past period that I’ve already reported on. Unexplained transactions posted in the past makes you look like you’re playing fast and loose with the books.

I don’t know if this is a change in accounting philosophy, but it seems like newer accounting systems assume that closing the books is optional. For QuickBooks Online, you need to dig around in the Account Settings…which I’ll show you in the video. I’ll also show you how to void a check in a closed period…which is needlessly complicated.

Check out the video below:

Useful Links

Learning to say “Thank you” with the IRS in mind

Jeff PospisilLeave a comment

What’s the worst thing that could happen if I don’t keep the IRS in mind when issuing Giving Statements or something to acknowledge gifts? Well…the IRS could disallow the donors charitable tax deduction which would lead them to have to pay more taxes. This would probably lead to a ticked off donor who will likely share this with other donors. You’ve basically discouraged anyone from wanting to give too generously to your church.

It really isn’t that hard to keep the IRS happy. All you need to do is properly document the gift (what did they give, who did they give it too, when did they give it) and include a simple statement that the donor didn’t receive any goods or services in exchange for the gift except for intangible religious benefits. You can sneak these element in and still have a nice “Thank you.”

Check out the video below:

Useful Links