ACCTivate!, Custom Reporting

New Customers by Month

This Acctivate Report is a rather simple one but can be quite useful. Do you want to send out monthly communications to your new customers?  Do you want to send a list of new customers to your sales staff with order totals so they can reach out and contact these new customers?  Or just report on new monthly sales?

Our Acctivate New Customers by Month Report looks for the date of a customer’s first invoice (not the date they were created but the first Invoice date) and if the date falls within the specified date range the customer is listed.  The original report was designed to show the Territory (or Sales Rep), customer name, phone number and amount of the invoice.  The amount displayed is the Invoice subtotal minus shipping.

The report is grouped by Month and Territory with a total new customer count and total sales amount at each level.

This report could be easily modified to add more contact info or be grouped differently to be more useful to your organization.  Maybe you need a report grouped by Rep then Date with page brakes after each Rep so you can easily distribute the report to supervisors.  Or maybe you want to take it one step further and add sales detail, or better yet add the ability to show or hide detail each time you run the report.

The foundation of this report is a simple one but is one that could be very helpful for your organization.  Please reach out to use if you are interested in this type of report, we’d be more than happy to help you get the data you need out of Acctivate.

new-customer-by-month-page-01

new-customer-by-month-page-02

new-customer-by-month-page-03

ACCTivate!, Custom Reporting

Multi Year Sales History/Forecasting Report

Knowing how your company is doing year over year is something every company wants to know.  You can look at a comparative P&L for this info but what if you want to know how sales for a specific customer are going, or maybe for a product?  Our Acctivate Multi Year Sales History/Forecasting Report was originally designed to group the results by Customer by Product.  Since the original design we have created a version that first groups by the Acctivate Product Class.  We could just as easily do this grouping by Sales Category.

This report shows sales history broken out by month for an entire year and when run for a range of years there is a row for each year, for easy month to month comparison.  Because the report is grouped by product we are able to show the sales amount total and the quantity total, which can be very helpful in giving you a quick way to identify possible trends and seasonality of your products.

The Forecast numbers are shown for future months and are based on Quotes that have been entered into the system.  This could be adjusted to use Booked Orders instead of Quotes if that makes sense for your organization.

As with any of our reports, this is a starting point and can be modified to meet your specific needs.  Just reach out to use and let us know how we can help.

sales-history

ACCTivate!, Custom Reporting, Uncategorized

Inventory Detail Journal by Account

This report can be used for reconciling any of the GL accounts Acctivate works with but it was designed to specifically reconcile the Accrued Purchase Receipts account in QuickBooks.  This can often be a very challenging task and we hope this report will help in your efforts. This report shows both the ins and outs into an account where the standard Acctivate Inventory Detail Journal Report does not.  Knowing both what came into an account and what went out is critical in your reconciling process and this report helps you do just that.

If you are having a difficult time reconciling your Accrued Purchase Receipts account? Contact us to purchase this report and make things a little easier during that reconciliation process.

inventory-detail-journal-by-account-page-01

 

ACCTivate!, Custom Reporting

Daily Open Orders Report

Our Acctivate Daily Open Orders Report displays open orders grouped by the due date and displays the daily total due in the header section of each days grouping.  It also includes a grand total for all open orders at the end of the report. This report can be used to make sure you don’t miss any orders or even help you plan your day.

The fields on this report are Order Number, Customer Name, Order Date, Due Date, Order Total and Workflow Status.  It is not currently setup to show order detail but that is something can be added for those needing something more.

daily-open-order-report

ACCTivate!, Custom Reporting

Backorder/Fulfillment Report

This Acctivate Backorder/Fulfillment Report is used to determine the quantity needed to fulfill all Open Orders. This report is grouped by Product and shows both a summary line and order details for each product. The summary line shows Product ID, Product Description, minimum SO age date for all open Orders, Open Order Average Price, Quantity needed for Orders, Quantity on Open Purchase Orders, Quantity on Hand, Quantity in Test Warehouse and Quantity needed to Fulfill Open Orders. The details displayed are the Order Number, Order Date, Promise Date, Price, Quantity Ordered and Quantity Needed. Since it may not always be necessary to see the detail of each order this report has the ability to show and hide the details.

realtime-backorder-page-01

 

realtime-backorder-page-02

Custom Advanced Reporting (CAR), Custom Reporting, QQube, QuickBooks

QuickBooks Custom Reporting Article Series on the Intuitive Accountant

Donovan has begun writing a series of articles for the Intuitive Accountant.  His first article, “QuickBooks Custom Reporting – A Series: Introduction” can be found here.  Donovan will be following up this introduction with future articles on Custom Reporting. Have a look and let us know what you think, then keep an eye out for the follow ups.

Consulting, QuickBooks

Custom Reports – Cash Register Receipt

One of the latest reports we created using the great new Custom Reporting tool in QuickBooks® Enterprise 2011 was a Cash Register Receipt Report that a client requested.  This report allows the client to enter a specific date and see the checks that were received for that day, what invoices they paid off, and then what account those checks got deposited into.

We have this report grouped by deposit account number and then by the check number.  The report displays the check number, date, and customer along with the payment total and total amount of discounts given for the invoices covered by that check.  Additional invoice details from the check such as date, memo, amount paid, discount amount, etc. are displayed as well.

This report will help the client with daily reconciliation of their finances, something very important to their business.  If you have a need to have all this type of info all in one place please feel free to contact us.  We will be happy to customize this report to make it fit the specific needs of your company, or use this as a starting place to create a whole new report for you.

Please note that this report was created using the QuickBooks® Enterprise 2011 Custom Reporting Tool and Crystal Reports XI.

Email us at quickbooks@acsi-az.com or call us at 620.454.9222 to discuss your custom reporting needs.

QuickBooks

Custom Reporting And QuickBooks® Enterprise 2011

We are very excited about one of the new features in QuickBooks® Enterprise 2011!  We haven’t really seen anything written about it yet so we thought we might as well take the opportunity to do so.  The Intuit Press Release “ QuickBooks® 2011 Saves Small Businesses Time in the Back Office” mentions most of the new additions to QuickBooks® Enterprise, however, one thing is not mentioned, the new Open DataBase Connection (ODBC) Driver.

This is not a replacement to the QODBC driver that has been available for some time now from FLEXquarters.  It is an additional tool that has been made available by the developers at Intuit.  This tool provides direct access to the QuickBooks® database via table views.  Alembic has been working with the Intuit development team since early in the development stages of this great tool and we have found it to be a very nice addition.  This driver provides strictly read only access to the database, unlike the advanced driver available by FLEXquarters which provides both read and write access.  However, when it comes to custom reporting read access is all we need and this driver is FAST!  Unlike the QODBC driver that uses the QuickBooks® SDK to build a secondary database to work from, this new driver works directly with the data.  We were able to develop a report that pulled thousands of records in just a few seconds.

In addition to being fast we also have access to data that is unavailable via the QODBC driver, due to limitations imposed by the SDK.  An example of this improved access is that we can now report on budget information contained within the QuickBooks® file.  In the past if we wanted to report on budget data we had to export the info into another program, such as MS Access, pull additional data in, and then develop our report off of that.  It was a very tedious and time consuming process.  With this new tool this will no longer be an issue!

Since this is a new tool it does take a little bit of getting used to.  You must create a reporting user within QuickBooks®, the driver is a File DSN as opposed to a System DSN, and the QuickBooks® file must be opened when accessing the data.  We were fortunate to work directly with the development team at Intuit, learning first-hand how tables are related to one another and what relationships are needed to get to the data correctly.  It was a great jump start for us.

We look forward to using this great new addition to QuickBooks® Enterprise 2011, which will be available for purchase September 27, 2010.  Contact us today to learn how you can purchase this #1 Rated financial solution.