Blog

How to print on pre-printed forms using Excel

Have you ever found yourself with a pre-printed form that needs to be filled in?

Using a typewriter is out of the question. One solution is a template that you can use and reuse to print the required information on the forms properly. Following are specific steps on how to print on pre-printed forms by creating a template in Excel and using the columns and rows as guidelines.

To print a pre-printed form using Excel, you’ll use the following:

Excel guide worksheet – includes a grid
Excel template – includes text boxes
You will then follow these steps to print on your pre-printed form using Excel — see link

https://www.quill.com/blog/tutorials/how-to-print-on-pre-printed-forms-using-excel.html

 

Having issues paying bills?

Businesses of all sizes need to pay their bills on a regular basis to maintain a good reputation in the marketplace and stay afloat. A small business needs to be savvy in paying bills, even with a computerized system. You don’t want to pay too slow or too fast — the idea is to pay right.

For specific solutions for:

-Paying the same bill twice

– Paying late

– Paying for damaged or never received items or services

– Paying online

Check out

https://www.quill.com/blog/tutorials/how-to-avoid-problems-when-paying-vendors.html

How to Print on Pre-Printed Forms

Stuck with a preprinted form that needs to be filled out but your handwriting may not be that clear? Yes, we still get those once in a while, like the red 1099 form. Strangely enough, these forms may be scanned, and if the letters are not that clear, the information may not transfer properly and it can be a pain.  The IRS may send a letter saying that  the name and social security or employer ID don’t match, for example, because the 1099 scanned changed a letter in the person’s name.

Using a typewriter is out of the question, so, what can you do? You could use Excel to be able to print on the form properly.  Here is a quick tutorial with screenshots and pictures about how you can fill these forms using Excel —

https://www.quill.com/blog/tutorials/how-to-print-on-pre-printed-forms-using-excel.html

Nonprofit must pay payroll taxes

Nonprofits may be exempt from paying income taxes, but they still need to pay payroll taxes. Taxes withheld must be remitted to the government and 1099 must be filed for contractors.

When payroll taxes are not paid up, people working for the nonprofit may be personally liable for the money.  Yikes!  Read more about this at:

https://www.nolo.com/legal-encyclopedia/what-happens-if-nonprofit-fails-pay-payroll-taxes.html

 

 

Restricted grants can be tricky

Look at ALL requirements of such grants, or you can get in trouble and may need to return the funds.  This can get really sticky.

 

http://www.thenonprofittimes.com/news-articles/u-chicago-donors-want-money-back/

Basic Internal Control for Nonprofits

The idea of separation of duties is not that obvious for many organizations, specially the ones with tight budgets, having one person handle too many functions because it seems simple and straightforward.  It’s usually a mistake.

The overall goal of separating duties is to have a system osf checks and balances to prevent losses and mistakes.

See the following articles about this topic:

https://sanfranciscohotelso.weebly.com/department/organizing-an-accounting-departiment

http://www.exemptmagazine.com/management_tips/separation-duties-effective-internal-financial-controls/

http://smallbusiness.chron.com/strengthen-office-billing-accounting-procedures-3933.html

 

 

How Nonprofit Tax Form Helps Management

The nonprofit tax form 990 contains interesting questions and requirements that should be reviewed by the board, not just by the financial people. I highly recommend to download and print the full form, even if the nonprofit doesn’t need to file it.  You can check out the core pages at https://www.irs.gov/pub/irs-pdf/f990.pdf

Take a look at the 990 page 6- “Part VI Governance, Management and Disclosure “section” and what is asked in this page– it may be an eye-opener for many.

Untitled

As you can see, this form raises good questions that may be used to improve operations.  According to the instructions on the top, saying “yes’ to lines 2 through 7b requires explanations and management should review these items carefully.

Line 2 is about identifying people who may personally benefit from the organization, a possible private inurement situation, usually a no-no for tax-exempt organizations or a hefty excise tax. The take away here — be careful with business relations involving board members.

Line 5 is about the loss of assets, an intriguing item on the tax return. A “significant diversion of assets” according to the IRS is embezzlement, fraud, theft or other inappropriate use of funds that is the lesser of 5% of current annual gross receipts, 5% of total assets at year-end, or $250,000.  According to a Washington Post report in 2013, more than 1,000 organizations marked “yes” here and most were for embezzlement.  Besides giving details of the problem, it’s a good idea to also disclose any new internal controls used after the problem was disclosed to prevent it from happening again. Note that this is NOT confidential information.

Line 11 specifically asks about top management getting copies of the tax return and how reviews are conducted.  The board must be engaged in this process, even if they are not financial people.  They cannot say that they don’t know or understand the tax returns.

Line 12 asks about conflicts of interest while line 13 is about whistleblowing, and line 14 covers document retention and destruction policy.  These lines underscore the need for written policies, and under the conflict of interest item, the need to monitor those regularly.  The idea is to say “yes” to all of these.  And the take away for management is to make sure these policies are followed up by procedures to make sure they’re not just “lip service.”

Line 18 reminds organizations to make certain forms available for review, as required by law.   Such reminders are all over the tax form, including reminding nonprofits about reporting contractors and gambling winnings.  Management could highlight those items and follow up on them with the finance department.

Also, note that the 990 asks for the nonprofit’s mission statement as the first line, and also on Part III- Statement of Program Services Accomplishments.  The idea here is to match the mission statement to the programs.  If an organization mission is to provide food for the homeless, but programs relate to buying books to schools, the nonprofit may be at risk to lose its tax-exempt status, which can be a major problem.

 

You can check the new edition of the book Nonprofit Finance A Practical Guide at https://goo.gl/M563u9