Drilldown in Accounting Software Reports and Spreadsheets

Drilldown is a convenient tool built into most modern accounting and business software programs.

Most of the time you run summary financial reports to evaluate business performance. When reviewing this information oftentimes certain numbers standout as unusual. Other times you just want to see what made up the summary number.

That is where drilldown becomes a very useful tool. Clicking on the row in question will open up either a more detailed report or the actual transaction, keying on the specific data for analyzing the summary number in question. Without this drilldown capability, you would have to open another report and set your parameters to get the detailed information you were looking to analyze.

Another effective use of drilldown is for editing erroneous transactions. For example, in reviewing a daily sales report, you find an entry error. Instead of having to go to an edit utility, find the transaction and edit it, drilldown gives you the capability to click on the report row and edit the transaction.

I do have one word of caution regarding programs that have drilldown capabilities. Report users may need to see certain summary information, but you don’t want them to see sensitive detail data or edit transactions. That is where you want to a select a program that offers security to prevent them from drilling down to information you don’t want them to see.

Payroll Software Direct Deposit – Publish Pay Advices Instead of Printing Them

Direct deposit is a payroll software tool that helps companies save time and money by depositing pay electronically into employee bank accounts. Many businesses are now going a step further and publishing and distributing their company's pay advices electronically instead of printing the pay stub on paper and handing them out or mailing them. Here are some great reasons for you and your business to try publishing pay advices electronically instead of printing them on paper.

  1. Easier distribution

    When you publish pay advices, an email notification is sent to employees, and from there they can click on a link to sign in and view their pay information. There is no longer a need to walk around with envelopes and distribute to each employee or pay postage and mail them. Distribution happens as soon as you send the email notifications, saving you the time associated with finding employees and handing them the paper documents, and you save money by cutting out the postage.

  2. Reduced paper and ink costs

    Pay advices typically use a sheet of paper and an envelope each. How many envelopes and paper would you save each year by eliminating the need for this paper each pay day? If you have 50 employees and they are paid every two weeks, it amounts to 1,300 envelopes and 1,300 sheets of paper. Help the environment and your bottom line by publishing electronically instead!

  3. Easy ongoing employee access to pay information

    Publishing pay advices allows the company to save pay data and make it available to employees, which in turn provides a secure place for employees to access their pay data with just a login name and email address. This saves the HR department time, and also lets employees know there is a central place for them to access their pay data any time they wish.

Using a publish pay advice application can help your company save time and money, and can also keep employees happy.

Purchasing and Inventory Management - Five Must-Have Tools

If you are involved in managing inventory, you are aware of the hassles that can arise due to purchasing issues. Having far too many of an obscure item or running low on a bestseller, are sure clues that you and your company can benefit from a more robust purchasing and inventory management tool. Technology has advanced over the years, such that you no longer need to keep track of purchasing activities on paper. Consider these benefits offered by software programs of today.

Order suggestion

A major benefit of using software is it can easily collect and analyze data, a task that would take an employee much longer to do manually. Look for a purchase order system that can analyze past demand, and suggest which orders need to be placed based on that knowledge. You can then use the report as a starting point, and use your own judgment on which purchase orders to create for which items. A purchase order system should also track who the item has been purchased from in the past and automatically order it from the last vendor and default the cost to the last cost paid for the item. If you aren't ready to make the jump to having the system recommend what should be ordered, look for a system that will allow you to simply enter a list of items that need to be ordered. The system will then assign the vendor and last purchase cost, so the purchase order is quickly and easily generated.

Flexible item ordering

Your business likely has its own set of product numbers that are different from your vendor's part numbers. Since your vendor is typically unfamiliar with your item numbers, it's best to place orders using their numbers. Some purchase order systems allow you to create and print purchase orders using both numbers, which is extremely helpful to you and your vendor. Another flexible purchase order tool is the ability to place orders in multiple units of measure, in case you need to purchase the item in one unit of measure and sell it in a different unit of measure.

Minimum and maximum quantity setup

This handy purchase order tool allows you to set up minimum and maximum amounts by item. This allows you to run a report to see which items are running low and need to be ordered, or which are overstocked and may need to be liquidated.

Drop shipment

Most businesses do receive requests for drop shipments, at least every now and then. If you need to order items and have your supplier ship them directly to your customer, a tool for handling drop shipments is a must. Handling drop shipments means that the system will allow you to specify a ship-to address that is different than your own address. Without this tool you will end up manually entering ship to data which results in wasted time and increased margin for error. This feature is crucial for those who drop ship large quantities of items. It should also allow you to identify the sales order to the purchase order, so that the sales order can automatically be invoiced as soon as the vendor communicates that the order has shipped.

Receive partial orders

As we all know, sometimes the orders we place are not always delivered in full. In these cases, it's helpful to have the choice of whether to receive the partial shipment and keep the rest of the purchase order open, or to simply receive the items and cancel the remainder of the items. Sometimes the vendor will notify you that they have shipped what they have and the remainder of the order will be canceled. A proper purchase order system will include an option that allows the user to cancel the remainder of an order, instead of having to manually cancel each line.

All of these purchase order software tools can help you keep your inventory stocked with the items you need, and lean on those that you don't. They also help you manage purchase orders more efficiently, saving your company time and money.

eFiling More Than a Trend...

This post is by Bruce Senti of Aatrix State and Fed Payroll Reports

State and Federal eFiling requirements are mandating more businesses to eFile payroll reports and payments every year.

More than a dozen states either lowered the threshold for employee count requirements or outright mandated that businesses eFile wage withholding, unemployment, and new hire reports.

The federal government requires virtually all employers to make withholding payments electronically.

The efficiencies provided government agencies by requiring eFiling will continue the trend towards requiring business to file reports and payments electronically.

Electronic tax administration is the foundation for a modernized IRS that provides secure, convenient, timely and accurate services to taxpayers, and to the tax professionals and IRS employees who serve them. (IRSOB-E report 2010 page 9)

The full vision for a modern ETA environment goes beyond just e-filing and seeks to make electronic interactions among taxpayers, tax practitioners, and the IRS the norm. These electronic interactions include the entire range of pre-filing, filing, and post-filing tax activities which taxpayers and their representatives may engage in with the IRS, including the ability to resolve taxpayer account issues over the Internet. (IRSOB-E report 2010 page 9)

The Board emphasizes the need to substantially increase the e-file rate, particularly among businesses filing employment tax returns, because it is crucial to the IRS to achieve the strategic 80 percent electronic filing goal. ( IRSOB-E report 2010 page 39)

“It’s good news for taxpayers as well, whether they be commercial or private filers, most experts agree, businesses that utilize e-filing have a 99 percent accuracy rate,” said David Deeter of Frazier & Deeter LLC.
Source: E-filing Hits Record High | Atlanta Business Chronicle

It is clear that the movement towards electronic filing is more than a trend. It is inevitable that virtually all reporting to taxing authorities will be electronic.

What to look for when choosing an eFiling solution.

With more and more agencies providing an eFile portal online which allows businesses to file reports electronically for free, you may wonder why would an efiling solution have any appeal.

You should look for a solution that has dramatic advantages over the use of the agency sites.

Simplicity

  • The interface is very simple. Choose any form from one screen, review/edit onscreen, and simple steps to eFile
  • One administrative account to track all confirmations, filings, and payments

Efficient

  • eFiling is completed within the payroll solution without additional exports, typing, and logging into multiple sites
  • Reports are filled in automatically with no need for manually transcribing
  • Reports are time-stamped and saved on your machine and accessible anytime for review or audit

Accurate

  • Reports are completed using the data within the payroll solution you use
  • The solution must guarantee compliance with all legislation, eFile requirements, and form changes.

Affordable

  • The solution should be offered as a subscription service which covers all your filing requirements for a single price. It should include all state and federal agencies you file with.
  • It should offer a W-2 eFiling service which allows you to complete all filings as well as employee distribution for less than $4 per employee (the average in-house cost).

eFiling More Than a Trend...

Electronic filing is not going away. In fact, it is the future for virtually all business activity. State and federal agencies are being legislatively and budgetary driven to take advantage of the efficiencies and cost savings eFiling affords them. Take great care in choosing a solution that meets all your needs and has the ability to grow and meet your future needs.

Which Business Gadget Can't You Live Without?

OK I admit it, I panic when I forget the charger for my iPhone, or even worse, forget the phone itself! I do internet marketing, so a lot of the functions I do here at Red Wing Software are immediately accessible from my phone. And not only that, I can check e-mails, use the internet, and use the multitude of useful apps, many of which have helped me in times of need! But alas, that is just me. I know that some of the things our customers here at Red Wing Software might find useful are a time clock, portable time capture device, and barcode scanners.

What business gadget can’t you live without?