The Ledger

Accounts Payable Roundtable Roundup

2009-11-19T13:03:00Z

In case you haven't heard, our first Accounts Payable End-of-Year Support Roundtable was a great success. If you missed it, make sure you register for one of our future sessions or check out the recording and PowerPoint from our last session. Here are some of the excellent questions your fellow AP users asked:

What are the requirements for filing electronically?
- Typically you are required to e-File if you are filing more than 250 returns; however, each state has specific guidelines so we recommend checking your state's website.
Can we use the pre-printed 1096 form sent by the IRS?
- You can use the forms sent to you, but we cannot guarantee that they will be aligned properly because each manufacturer prints the form slightly different on each page. We only guarantee the alignment of forms purchased from Blackbaud Forms.
How do you know how many 1099s will print before you actually print the forms?
- You can either use the Vendor Activity Report or preview your forms prior to printing.
How does FE handle the Royalties box on the 1099?
- FE is configured to handle and report based on the different limits of each box.
If you have multiple payer tax ID's sharing a database, how do you segregate the 1099s when printing?
- You will need to create two queries with the 1099 activity for each tax ID. Then print your 1099s in two batches using the query as a filter. Make sure you change the tax ID defined in between printings.
Should the query to determine 1099 amounts be filtered by invoice date or payment date?
- Payment date.
Why can't you adjust 1099 amounts on an invoice?
- The distribution is locked down once the invoice is paid.
When you process a 1099 adjustment, why isn't it saved permanently?
- You are able to make changes to adjustments so that in the future, if a mistake is found, you have the ability to delete or modify an existing adjustment.
Is there a global change for vendors that were mistakenly brought over as 1099 vendors and now have amounts when they shouldn't?
- While there is no global change for this, you can create a query of 1099 vendors and easily open each vendor from the Results tab to make the necessary changes.
Where is this link to the 1099 wizard located in the software?
- Beginning in version 7.82, the link can be found in the Help file which can be accessed either by pressing F1 or clicking the How do I adjust Vendor 1099 box amounts in Mail, Forms.
How do you set permissions for 1099 processing?
- Give users rights to Mail and 1099s in the Personal Information Shared Component.
Are there any plans to incorporate 1099R info into Blackbaud?
- This has been filed as a suggestion and may be included in a future version of FE.
How do you export forms to file through the IRS FIRE site?
- When printing forms, you have the option to create a magnetic media file which can be uploaded using the IRS FIRE site.

Itty Bitty Timesavers

2009-11-17T12:57:00Z

Hey blog readers! I found a great post on The Book Bag that I wanted to share with you. If you've liked The Ledger time savers you must check out the Itty Bitty Timesavers post. It lists some great tips and tricks to save you a few seconds here and there. Remember, a few seconds saved on each task quickly adds up to extra hours and who can't use more hours in their day ?

Talk to you soon!

AP and PY End-of-Year Support Roundtables

2009-11-12T17:01:00Z

It's been a year since you last created your W-2s and 1099s. Do you need a refresher or are you new to the process? If you have any questions about end-of-year for AP or PY, make sure you attend one of our end-of-year Support Roundtable sessions.

The Accounts Payable End-of-Year Support Roundtable will provide an overview of the end-of-year process, including running end-of-year reports, setting up vendors to track 1099 activity, creating 1099 forms, making 1099 adjustments, and a question-and-answer period at the end of each section. Here are the session dates:

Thursday, December 10 from 2:00 to 3:30 p.m. ET
Wednesday, January 6 from 2:00 to 3:30 p.m. ET

There are only 150 "seats" available for each session so don't delay, register today!

The Payroll End-of-Year Support Roundtable will provide an overview of the end-of-year process, including running end-of-year reports, creating W-2 forms through Aatrix, making W-2 adjustments, and a question-and-answer period at the end of each section. Here are the session dates:

Wednesday, December 9 from 2:00 to 4:00 p.m. ET
Friday, January 8 from 2:00 to 4:00 p.m. ET

There are only 65 "seats" available for each session so so don't delay, register today!

The Great and Powerful Wizard

2009-11-10T20:23:00Z

Amounts? And Information? And Tax Forms. Oh my! Don't feel like the Scarecrow when it comes to correcting your 1099s and W-2s. Go see [speaking in a booming voice into a microphone] the great and powerful Wizard of 1099s and W-2s for help.

Our brand new 1099 and W-2 Wizards are easy-to-use interactive help pages to take you step-by-step through the process of correcting all information and box amounts on 1099 and W-2 forms. They even have examples and screen shots! It's almost like having a Support analyst right there in your office helping you make the correction.

To use the wizards, simply open the 1099 Wizard or W-2 Wizard, hover over the box to adjust, click, and follow the steps. It's that easy!

Have you used the 1099 or W-2 Wizard? Share your experiences and feedback by leaving a comment. Talk to you soon!

The Ledger Lowdown: Vendor Tax ID Woes

2009-11-04T17:49:00Z

Hey blog readers! We are often asked why Accounts Payable users are not able to update a vendor tax ID, so I thought this would be a helpful topic to talk about today.

Beginning in The Financial Edge version 7.70 we implemented personal information security. This additional security option allows you to specify which users can view and edit information such as Social Security Number, credit card numbers, bank account numbers, and vendor tax IDs. To ensure this personal information is secure, the personal information options are not marked when you create a new security group or update from a version prior to 7.70.

To be able to update the field, adjust the Shared Component Personal Information options in the users' security group. For complete steps, take a look at Knowledgebase solution BB181316.

Make sure you only assign rights to personal information for users that need to access it in order to perform their job. If you are not sure what rights are appropriate, check out What is Blackbaud's recommendation for personal information best practices?

Talk to you soon!

Make it Feel Like Home: The FE Home Page

2009-10-27T12:56:00Z

Do you run the same saved reports and queries daily, weekly, or monthly? Save yourself time by adding links to them on your Home page. This simple process will help streamline your regular tasks by accessing common FE reports and queries, websites, or non-Blackbaud products, such as Word or Excel, from one location. Remember, these settings follow your user name, so you don't have to worry about resetting them, or doing more work , if you switch workstations.

The first thing you want to do is set FE to start on the Home page. To configure this, select Tools, Options from the menu bar, select the General tab, and then select Home from the Start on this page drop-down list.

If you have several items for a given task, such as the reports, spreadsheets, and queries needed for reconciliation, create a folder to keep organized. To add a new folder to the Home page, follow these steps:

Select Favorites, Organize favorites from the menu bar.
Highlight the appropriate home page and click New Folder.
Enter the name of the new folder and click OK.

Ok, now that you have set FE to open on the Home page of your choice and created any necessary folders, it's time to create the links.

For links to FE reports or queries:

Open the report or query and select Favorites, Add to Favorites from the menu bar.
Enter a name and description.
In the Create in field, select the modules name, such as Accounts Receivable, for the link to display on the Home page or the folder listed below the module name to add the link to the folder on the Home page.
Click OK.

For links to non-Blackbaud products or website:

Drag the saved file into the FE shell. You will see the document open and display within the shell.
Note: To create a shortcut to a Web page, right-click the desktop, and select New, Shortcut. Paste the entire URL in the location box and click Next. Enter a name for the shortcut and click Finish. Drag the shortcut on the desktop into the FE Shell.
Select Favorites, Add Page to Favorites from the menu bar.
Enter a name and description.
In the Create in field, select the modules name, such as Accounts Receivable, for the link to display on the Home page or the folder listed below the module name to add the link to the folder on the Home page.
Click OK.

Make sure you also add links to our online resources for quick reference.

Knowledgebase: http://kb.blackbaud.com
FAQs: http://www.blackbaud.com/support/faqs/fe7.aspx
User Guides: http://www.blackbaud.com/support/guides/fe.aspx
Newsletter back issues: http://www.blackbaud.com/support/newsletters/supnewsletters.aspx
The Financial Edge Forums: http://forums.blackbaud.com/forums/4.aspx
The Ledger blog: http://forums.blackbaud.com/blogs/financialedge/default.aspx

Stay tuned for more helpful hints to make The Financial Edge feel more like... home.

Talk to you soon!

Keep that Chart of Accounts from Exploding

2009-10-22T13:48:00Z

Resist the urge to add yet another account segment or code, and instead consider the following:

Lifespan
Budgeting
Equity Retention
Transaction Balancing

The above points will help you decide which of the following transactional characteristics is appropriate:

Projects
Transaction Codes
Account Attributes
Transaction Attributes
Project Attributes

While the above have different abilities, each can at least be reported on. For example, I can use a Transaction Attribute to report activity group by Location without creating additional Accounts.

Also, I'm always impressed by individuals who can tell me exactly what account '01-4512-22-3-84' is without reference. Instead of referencing numerical code tables, or worse sticky notes, you can book transactions using plain English.

The table below outlines the basics of each characteristic.

Characteristic	Retain Equity?	Budget?	Require to Balance?	How many can you define?
Project	Yes	Yes	Yes	Unlimited
Transaction Code	Yes	Yes*	Yes	Five
Transaction Attributes	No	No	No	Unlimited
Account Attributes	No	No	No	Unlimited
Project Attributes	No	No	No	Unlimited

Now that you know account segments aren't the only show in town ... be kind to your Chart of Accounts and keep it from exploding.

Create a Cookie Cutter Journal Entry Batch

2009-10-19T13:35:00Z

Do you enter the same journal entry batches each month for utility bills or have a grant that receives the same percentage of funds on a regular basis? Hate having to create the same batch each month? Then recurring batches are here to save you time and the worries of an incorrectly keyed journal entry.

Recurring batches are templates that can be loaded to quickly create regular batches. There are two types of recurring batches: Recurring Amount and Recurring Percent. Recurring Percentage batches are useful if you have regularly occurring transactions that require the same percentage of debit and credit amounts. Recurring Amount batches are useful if the batches post to the same accounts each time. If they post with the same amount you can enter the amount, or if the amounts fluctuate you can omit this information in the Recurring Amount batch.

To create a Recurring batch template, select the type of Recurring batch from the batch type dropdown menu in Journal Entry. Create the batch as normal, giving it a Batch ID and description. You can then enter your transactions and any distributions that you want to include in the Recurring batch. For more information on creating a Recurring batch check out Knowledgebase BB92224.

So you've got a recurring batch template set up, now what? You can easily create a regular batch from the recurring batch template by creating a new regular batch. Once the new regular batch has been created, you can select to load the recurring batch template by selecting Batch, Use Recurring Batch from the menu bar. Select the recurring batch template with the pre-defined transactions that you want to use, then enter a post date and a transaction amount in the appropriate fields, and click OK to populate the preset information into the batch. Enter any additional transactions or edit distributions as needed. You have now created an open batch that you can save, validate, and post!

Payroll Post Notes: Update Compensation Types with Ease

2009-10-15T12:00:00Z

Do you have employees receiving pay raises or do you need to update benefits and deductions? Don't go through the process of first changing the existing record to inactive and then adding a new record, trying to remember the options selected on the original record; do it all at once using the Change Compensation Wizard. This wizard allows you to copy and update an existing pay type, benefit, or deduction while replacing the existing record.

Before we continue, I should let you know exactly what happens when you use this handy dandy wizard. The existing compensation type will be expired on the date of your choosing and the new updated compensation type will be automatically added to the employee record. Nothing too complicated, but I wanted to let you know that both compensation records will remain on the record as a paper trail.

Here's how to use the Change Compensation Wizard:

In Records, Employees, open the employee record.
Select the Compensation/Deductions tab.
Click Change Compensation.
In the Change Compensation Wizard, select Copy Existing [compensation type].
In the ID field, click the binoculars and select a compensation type to copy.
Note: You must select a compensation type currently assigned to the employee.
Mark the Expire this [compensation type] checkbox and enter an effective end date.
Mark the Increase/Decrease [compensation type] using checkbox and enter an amount.
Note: To increase the [compensation type], enter a positive number. To decrease the benefit, enter a negative number.
Click OK.

The new compensation type will become effective the day after the existing compensation type expires.

Enjoy your extra time and talk to you soon!

Due-to/Due-From Vs. Transfer Accounts

2009-10-12T14:13:00Z

Have you ever wondered whether you should use a Due-to/Due-from account or a Transfer account? Well, that I cannot tell you. However, what I can tell you is the difference between the two account types so that you can make a decision as to which one to use.

Due-to/Due-from accounts are similar to liability accounts in that they maintain a balance at the end of the year that is carried forward to the next year. Therefore, Due-to/Due-from accounts appear on your Balance Sheet. This account type is usually used for transferring money between companies.

Transfer accounts, on the other hand, are similar to an expense account whose balance is closed into the fund balance account at the end of the year. Therefore, Transfer accounts appear on your Income Statement. This account type is usually used for balancing transactions across funds.

So, still not sure which type to use? I suggest you speak with a CPA for an answer to that question.

Journal References Are Supposed to Mean Something?

2009-10-06T12:11:00Z

Do you ever wonder what the transaction Reference column on the General Ledger Report or Post Report means? If you do, then this post is for you! The Reference, also known as journal reference, is created when you post from subsidiary ledgers (AP, AR, FA, CR, SB, and PY) or in detail from The Raiser's Edge. The journal reference defaults are defined in Configuration, can be customized for your organization's needs, and can even be defined for each transaction type.

Journal references are displayed on:

The transaction detail on an account record
The post report
The Journal Entry batch
All General Ledger reports where Reference is an available field

There are a few things to keep in mind when you set up your journal references. First, the total number of characters in a journal reference cannot exceed 50 characters. Secondly, changes to journal references are not retroactive, so the changes will only affect items that are not yet posted. Finally, when you create the references, make sure you include necessary details for an effective audit trail.

So let's get to the process...

For FE subsidiary ledgers, go to Configuration and click Posting Information. Then highlight the transaction type and select the appropriate field names and field lengths. Remember to define the journal reference for both the debit and credit side of transactions by marking the Debit or Credit option in the dark gray bar.

To define the journal reference in RE, go to Configuration, click General Ledger, and select the field names and lengths; you will see a sample of the journal reference at the bottom of the screen.

Don't see what you want? You can add custom fields to FE or RE by clicking Fields and entering the new name. Not sure how or why you would need a custom field? Try using them to emphasize specific transaction types such as INT- for Interfund entries and APPL- for Application entries.

For more information on customizing journal references or step-by-step instructions, take a look at the Posting Information section of the RE or subledger Configuration Guides.

The Straight Line Breakdown

2009-10-02T12:23:00Z

Straight line depreciation is one of the most common methods used when depreciating assets. Have you ever wondered about the list of conventions, and what they mean, and what they do? I hope these explanations help you understand which depreciation convention is right for your assets!

Full Month

Depreciation begins with the first month in service
Equal depreciation amount every month, determined by the total number of months in service
Continues throughout useful life

Mid Month:

If the date in service is before the 16^th, a full month's worth of depreciation calculates the asset's first month
$0 is charged in the first month if Date in Service is after the 15^th

An ‘extra' month is added to the asset's useful life to compensate for the amount not charged in the first month of life.

Zero Month:

No depreciation is calculated in the asset's first month in service
Beginning with the second month, depreciates like Full Month convention

Full Year:

An entire year's worth of depreciations calculates in the first year, regardless of the month in service date.

During the first year, the annual depreciation will be distributed over the number of periods in service for the first year. Example: If the asset is placed in service in the third period, then the first year's depreciation will be evenly distributed between periods three through twelve.

After the first year, the asset will depreciate in the same manner as Full Month.

Half Year:

One half of a normal year's depreciation will be depreciated in the first year.

The actual amount of depreciation will be distributed over the number of periods the asset is in service during the first year.

Beginning with the second year, a full years' depreciation is taken
Continues until the last year, when an additional half year's depreciation is taken. This is like the Half Month convention we discussed earlier. The additional year is added to compensate for the half year skipped in the beginning of the asset's life.

Zero Year:

Just like Zero Month, no depreciation is calculated in the first year of service
In the first period of the asset's second year, depreciation will begin calculating in the same manner as Full Month.

Duplicate Vendors?

2009-09-28T18:39:00Z

Many times vendors are entered into FE twice by accident. This is usually done because a user cannot find a vendor and then assumes that the vendor has never been entered into the system.

Fortunately this problem can be resolved easily and quickly. There is an option called Merge Vendors located in Administration. This will allow you to combine the two vendors into one, activity and all.

As you can see, there are two fields on this screen. So what's the difference? Well, Primary vendor is the record you would like to merge into or the record that will remain. Duplicate vendor is the record you would like to merge into the primary vendor or the record that will be removed.

So let's say we want to merge two vendor records.

Be sure you have a current backup.

Begin by selecting the vendor records by clicking on the binoculars and browsing for the records. Then click Merge Now to combine the two records into one: the primary record. It's as simple as that!

Oh and by the way, this same process is available in Accounts Receivable for clients.

Purging Records

2009-09-24T12:17:00Z

Have you ever wanted a record, or a group of records just gone? I mean completely gone. This is something you can do in The Financial Edge. We call it purging records.

Why would you want to purge records? There are a variety of reasons. You may need to purge records to make corrections, such as needing to reprint a check using the same check number. Purging records may also improve database performance. For example, if your vendor Activity tabs take a long time to load, it may be beneficial to purge old vendor activity. Purging records to help with performance issues should be a last resort after trying the steps in How to troubleshoot performance issues.

But wait! Before you continue, understand that purging records removes them permanently from the database and they can never be recovered. We always recommend creating a backup of your database before completing a purge process. This way if you need to review the purged information, you can use the back up.

Here are the records that can be purged in The Financial Edge:

Need to Record Handwritten Checks?

2009-09-22T13:13:00Z

If you handwrite a check to a vendor, how do you record the payment and reflect the invoice as paid? Record a manual check. The manual check allows you to enter the payment and select the invoice(s) paid by the handwritten check.

Before you can record a manual check, you need to make sure your bank is configured to allow them. In Banks, click Edit account details under General tasks. On the Bank Account screen, select the Payments tab. In the Transaction Type column, locate Manual Check for AP. Mark the Allow? checkbox and select the appropriate Numbering option from the drop-down list. Depending on the Numbering option selected, you may also need to enter a Next Number, which is the starting number. Click Save and Close and you're ready to enter your handwritten check.

To record the check:

In Banks, select the appropriate bank.
Under Payment Tasks, click Create a manual Accounts Payable check.
Select the vendor name.
Enter the invoice and check information.
Select the Invoices tab.
Mark the Pay? checkbox for the invoice(s) paid by the manual check.
Select File, Record and Close from the menu bar.

That's it you're done. Happy check writing! Talk to you soon.