News

End of Year Procedure

Below is a brief point-form summary of what needs to be done in respect to the End of Financial Year.

IMPORTANT: Please make sure that a End Of Financial Year Backup is done and Removed from your Current Backup set and KEPT

SITES THAT ARE NOT RUNNING READYSELL GENERAL LEDGER

Please follow steps below:

  1. Set up a folder on the main drive on the server and call it something like ‘EOYJune2010’ and archive all relevant reports into there.
  2. If you are doing a stock take please ensure that you have printed and archived a stock on hand report BOTH BEFORE AND AFTER THE STOCKTAKES.
  3. Ensure that you have printed and archived The Stocktake Variance reports
  4. Ensure all data for the last day in June is completed and dated and entered correctly into Readysell.
  5. At end of Trade on the 30/6/2010 Run a Stock On Hand Report, Print it as well as ARCHIVE it into a safe folder on your hard drive.
  6. Print out whatever other relevant reports that you may require in respect to sales, stock on hand, etc.
  7. You may not run your debtors or creditors end of month as yet as you are probably waiting to download your bank statement early the next morning as you will have direct deposits and electronic transfers and miscellaneous transactions dated up to 30/6/2010.
  8. If this is the case, then the next step would be at end of trade on the 30/6/2010 please ensure that a number of BACKUPS are done.
  9. Firstly the normal backup then another backup and keep it off site as well as label it.
  10. If you require the data to be backed up into a separate database as well please contact Readysell.
  11. Early the next morning on the 1/7/2010 no transactions in sales or purchasing should be backdated into June 2010.
  12. Unless of course if your company policy for Suppliers is different and you allow the first week of the next month for supplier invoicing.
  13. Bear in mind if you are receipting supplier invoices re stock on hand, the stock on hand figures on the stock on hand report that was run 30/6/2010 will not change due to the back dating.
  14. Down load your bank statement and enter all deposits and payments and misc entries that have not yet been entered into Readysell for June and date them the DATE (JUNE) as per your statement.
  15. These can be backdated as you have not yet run your Debtors Trial Balance or Statements.
  16. Allocate the payments then run through your normal End of Debtors process.
  17. Remember to archive debtors trial balance and debtors statements and transaction listing.
  18. Make sure you do you last Bank Reconciliation dating it month ending 30/6/2010.
  19. Please ensure with Bank Reconciliations that you do not present any forward dated transactions into the end of financial year bank reconciliation.
  20. Print out your both Bank Reconciliation Reports and attached them to the bank statement.
  21. Any customer payments that are received on the 1st July 2010 can be entered but please DO NOT ALLOCATE THEM until the trial balance and statements have been run for JUNE 2010.
  22. As for suppliers if you do not cut off exactly on the 30th June 2010, then please ensure you DO NOT RUN A CHEQUE RUN for July until you have finalised June and run and archived your Supplier Trial Balance. If you do need to pay suppliers in July, then don’t do a cheque run whereby allocation is automatic, enter the payments as manual SUPPAY and date them July BUT DO NOT ALLOCATE THEM IF YOU HAVE NOT CLOSED OFF SUPPLIERS FOR JUNE.

SITE THAT ARE RUNNING CASHBOOK AND GENERAL LEDGER

Please follow steps below:

  1. If you are doing a stock take please ensure that you have printed and archived a stock on hand report BEFORE AND AFTER THE STOCKTAKES.
  2. Also ensure that you have printed and archived the Stocktake Variance reports.
  3. Ensure that all data is entered and dated correctly for the last day in June is completed in Readysell.
  4. Ensure that all transactions that physical reduce or increase stock like stock adjustments, stocktakes, sales, purchasing, credit requests, stock transfers are entered prior to Running Your End of Year Stock on Hand Report.
  5. At end of Trade on the 30/6/10 Run a Stock On Hand Report, Print it as well as ARCHIVE it into a safe folder on your hard drive.
  6. Print out whatever other relevant reports that you may require in respect to sales reports, stock on hand, etc.
  7. You may not run your debtors or creditors end of month as yet as you need to download your bank statement early the next morning as you will have direct deposits and electronic transfers and miscellaneous transactions dated up to 30/6/10.
  8. If this is the case, then the next step would be, at end of trade on the 30/6/10 ensure that a number of BACKUPS are done.
  9. Firstly the normal backup then another backup and keep it off site as well as label it.
  10. If you require the data to be backed up into a separate database as well please contact Readysell.
  11. The next morning on the 1/7/10 no transactions in sales or purchasing should be backdated into June 2010.
  12. Unless of course if your company policy for Suppliers is different and you allow the first week of the next month for invoicing.
  13. Bear in mind if you are receipting supplier invoices and stock on hand, the stock on hand figures from the stock on hand report that was run 30/6/10 will not change due to the back dating.
  14. Down load your bank statement and enter all deposits and payments and misc entries that have not yet been entered into Readysell for June and date them the DATE (JUNE) as they are on your statement.
  15. These can be backdated as you have not yet run your Debtors Trial Balance or Statements.
  16. Allocate the payments then run through your normal End of Debtors process.
  17. Remember to archive debtors trial balance and debtors statements.
  18. Make sure that the last Bankrec for Each Bank Account is dated and extracted to 30/6/10.
  19. Please ensure with Bank Reconciliations that you DO NOT PRESENT/TAG any forward dated transactions into the end of financial year bank reconciliation.
  20. Print out your both Bank Reconciliation Reports and attached them to the final bank statement for that financial year.
  21. Any customer payments that are received on the 1st July 2010 can be entered but please DO NOT ALLOCATE THEM until the trial balance and statements have been run for JUNE 2012010.
  22. As for suppliers if you do not cut off exactly on the 30th June 2010, then please ensure you DO NOT RUN A CHEQUE RUN for July until you have finalised June and run and archived your Supplier Trial Balance. You can enter manual Supplier Payments and date them July BUT DO NOT ALLOCATE THEM IF YOU HAVE NOT CLOSED OFF SUPPLIERS FOR JUNE.
  23. The General Ledger is an overnight process which runs as part of the End of Day Backup. So that means that all data entered into Readysell on the 30/6/10 will update the General Ledger and Generate Journals sometime after trade and ready for reviewing the next morning.
  24. Check the General Ledger the next morning and Print off a Profit & Loss, Balance Sheet and General Ledger Trial Balance.
  25. Ensure you archive these as well.
  26. The general ledger does not have to be closed off at the end of June. It can be left open for Manual Journal Entries or Miscellaneous Debits and Credits into Customers or Suppliers that have no physical affect on Stock on Hand only Miscellaneous Expenses.
  27. Ensure that you have run your General Ledger Postings Report and compared it to your source modules of Sales, Customers, Suppliers and Cash Book (General Ledger Balancing Act).
  28. Ensure that at the beginning of the next month you have closed your financial Period to prevent Back Dating.
  29. Once you are ready to close off the financial year, you will need to rerun your 3 general ledger financial reports, send them off to your account to be reconciled.
  30. Usually your account will provide you with a reconciling journal for that financial Period.
  31. That journal needs to then be entered into Readysell in the right Period.
  32. Then you need to contact Readysell so that you can run and clear that financial year (P&L Appropriation Process).

Adding Images To Your Readysell Product File

A new document has been created and called “Adding Images To your Readysell Product File”. This document will show you how can can associate images of products for display in your Readysell system.

You can download the document in the “Support Downloads” section of our web site under “Readysell Version 7” > “Basics” (click here). Please download this file for future reference by right clicking on the file name and selecting “Save Target As”.

New Documents Now Available

3 new documents relating to Readysell 7 functionality have now been released:

  1. V7 Creating Your Own Flyers/Promotions (Available under the “Products and Stock” category)
  2. V7 Adding On A New Staff Member Operator Code (Available under the “Basics” category)
  3. V7 Customer Payments At The Front Counter POS (POS = Point Of Sale) (Available under the “Sales and Service” category)

You can download these and all of our documents from the Support Downloads section on the Readysell Website.

Last Week’s Webinar

A big thank you to all of our customers that attended the Readysell-Office Brands Integration Webinar last Thursday. This was our first experiment with the format and we believe it was a huge success.

We had almost 30 representatives from Office National and Office Products Depot stores around Australia in attendance and had some great questions and feedback. We hope that we cleared up the majority of the outstanding issues around RObI, WebSphere and how they relate to you as a Readysell user.

As a follow up, we would like to hold another integration-related Webinar after the Easter break. This time, we are looking to run it as an “open forum” format where everyone will have the opportunity to ask questions at any time. In preparation, we would like to know if you have any areas that you would like covered, feedback on what days/times suit you best and any suggestions for improvements we can make on our last Webinar session.

We look forward to hearing from you and will have more information about our next webinar in the coming days.

Readysell-Office Brands Integration Webinar

This coming Thursday the 25th of March at 2pm Sydney time, Readysell will be hosting a Webinar covering all of the integration points between Readysell and WebSphere. We will be paying specific attention to the recently added Contract Upload component, however will also be covering Order Imports, Store Product Uploads and Invoice Uploads.

We urge all of our Office Brands customers to join the Webinar to ensure you are fully aware of the recently implemented changes, how they effect you and any work that will be required from your side to start the integration process and keep it running smoothly.

Please reserve your Webinar seat now at by going to https://www2.gotomeeting.com/register/166895947

If you have any trouble doing this or have any questions or suggestions for topics to be discussed, please contact adam@readysell.com.au.

Microsoft Security Essentials Update

imageFor our customers who have moved over to Microsoft Security Essentials, there has been an update to the software and we recommend you check that you are up to date.

For users who are running Windows XP as an Administrator, no action is required. However, if you are running as a User in XP or using Windows Vista or Windows 7, you should run through the following to ensure you are up to date.

  1. Double click on the MSE icon in your tray. It should appear as a Green, Red or Yellow building with a flag on top
  2. Ensure that your computer status is “Protected”. If not, and you see the screen to the right, click “Upgrade now”

Management Report Feedback

You should now have received your new Readysell 7 Management Reports. You can locate them on your Readysell Report Wizard screen.

Report List

For our customers that haven’t had the time to look at them yet, we would like to provide a quick summary of the information they contain. We look forward to hearing your feedback and hope that these reports prove useful to your business.

All sales by date by product detail – Sales Description

All sales by date by product detail – Sales Description

Bank Deposit Report – Summary on bank deposits

Bank Deposit Report – Summary on bank deposits

Customer Trial Balance

Customer Trial Balance

Customer Sale Summary by Rep by Period Grid

Customer Sale Summary by Rep by Period Grid

Department Sales By Period Summary – location / department sales

Department Sales By Period Summary – location / department sales

Customer Sales By Period Summary Grid

Customer Sales By Period Summary Grid

Sales Comparison Against Stock Receipts

Sales Comparison Against Stock Receipts

Top Selling Product Summary For A Range of Customers

Top Selling Product Summary For A Range of Customers

Product List

Product List

Daily Report 1 SalesByDaySummary – Daily Sales Report

Daily Report 1 SalesByDaySummary – Daily Sales Report

Sales by Period by Supplier Summary

Sales by Period by Supplier Summary

Daily Report 2 Sales Detailed By Day – Daily Sales Report

Daily Report 2 Sales Detailed By Day – Daily Sales Report

Sales Orders Outstanding – Summary of any outstanding orders

Sales Orders Outstanding – Summary of any outstanding orders

Stock On Hand Report

Stock On Hand Report

Readysell 7 Management Reports

Readysell Report WizardThe new Readysell 7 Report Writer has been available to our customers for some time now and the feedback we have received has been very good. Building on this feedback, we have released a new group of Reports called under the category “Management Reports”.  Tonight we will release a full update to all of our Readysell 7 customers to ensure all the reports are available to you.

The list of new reports that are being released includes:

  • All Sales by Date By Product Detail
  • All Sales Transactions Codes by Date Detail By TransCode
  • Bank Deposit Report
  • Customer Sales By Period Summary Grid
  • Customer Sales Summary by Rep by Period Grid
  • Customer Trial Balance
  • Daily Report 1 SalesByDaySummary
  • Daily Report 2 Sales Detailed By Day
  • Department Sales By Period Summary
  • Product List
  • Purchase Order Line Details By Transaction No Selection
  • Purchase Order Lines For One Transaction NO
  • Purchase Receipt Listing By Receipt No
  • Sale Outstanding in Details By Date Range
  • Sales By Period By Supplier Summary
  • Sales Comparison Against Stock Receipts
  • Sales Orders Outstanding
  • Stock On Hand Report
  • Top Selling Products Summary For A Range Of Customers

You can download a spreadsheet with a full list of available reports here.

Readysell to WebSphere Contract Integration

After extensive testing at a number of pilot sites, Readysell is pleased to be rolling out the contract price integration component of RObI to all Office Brands members.

We are currently in the process of installing the necessary components on each server – this should be completed shortly. However, we will not be turning on this functionality at your store until the following prerequsites are met:

  1. You have read the relevant section of the Readysell-Office Brands Integration User Guide (available in the Support Downloads section of our web site). Contract price integration requires that you understand how the process works.  In particular, only certain types of contracts are being sent to WebSphere.
  2. You have deactivated or deleted any manually created contracts in WebSphere which duplicate your Readysell contacts (and hence create the potential for conflicts).
  3. You contact Readysell and confirm that you wish to have this functionality enabled.

We believe that this functionality can save you a great deal of time and effort and hope to have this running at your store as soon a possible. If you have any questions regarding the above process, please email adam@readysell.com.au or leave a reply on this blog post.

Readysell 8 is Coming

Readysell is presently working to produce a next generation ERP package that includes all of the features required in a best of breed ERP system. We are rewriting Readysell from the ground up to utilise the latest technologies software standards.

Outside of regular support, completing Readysell 8 is our core priority for 2010. As a result, as much as practical, we will not be adding new features to the existing Readysell 7 software. We will still be fixing bugs and supporting all existing Readysell 7 features as usual. We believe this is focus will be in the medium term interest of all members.

Below you will find a brief outline of some of the new features and improvements coming in Readysell 8. We are confident you will find value in what’s coming and are able to cooperate with us as we focus more of our attention at our upcoming product.

Latest Technologies

Readysell 8 is built using the latest Microsoft .NET technology. This provides Readysell with a clear technology path backed by the world’s most prominent software vendor.

Our development platform keeps the Readysell 8 business rules separate from the Windows and web technologies currently being used to deploy them.  As a result Readysell 8 currently has parallel versions for Windows and the web. In the future we will have additional versions utilizing the best emerging technologies.  The Windows version is most suitable to local workstations where it gives the best user experience. Sales reps and remote staff can work on the same system using the included web version.

Readysell 8 can be substantially standardized across the group and tailored for members without having to request program changes.  All the screens and reports can be redesigned using a drag and drop report and screen designers included in the program. Those changes can be made centrally and deployed to member’s systems.

Readysell 8 can run on almost any database engine. Our current database engine has also been upgraded to provide unparalleled transaction-based data integrity.

Extensive Service and Photocopier Module

Readysell 8 features a full service module. Our service module includes photocopier service, support and automatic billing. Meter readings and service requests can be entered in many ways. For example, customers can enter meter readings via the web.  Each photocopier can have any number of meters. Meter readings associated with each meter are retained as drill down history.  Readings are used to generate billing, schedule service jobs and to chase up missing meter readings. Warranty and service contracts are associated with photocopiers. Service jobs can be created for photocopiers or any other service work. Jobs track the goods they are waiting for as well as time and materials used.  Service billing and profitability reporting is automatically calculated for all service jobs.

The system monitors your service operations just like the rest of the business. Alerts are automatically generated and the relevant staff are emailed when actions are required. Such as when service is due, meter reading required, invoice generation overdue etc. Repeat requests for action are automatically generated for your staff in respect to all jobs that are late until the job is successfully completed.

Enhanced General Ledger

Readysell 8 features a simple yet powerful real-time General Ledger module. As any transaction is entered you can immediately drill up to the summary accounts. Accounts staff can also drill down on screen through daily summaries to the individual lines that make up each account posting. There is a transparent association of all financial summaries to their source transactions and all source transactions to their financial summaries. This gives an excellent real time audit trail with a high degree of usability and integrity.

Business Intelligence for Staff and Operations Management

Readysell 8 monitors the health of your business minute by minute. The system watches to see if something needs to be done. Like a product needs to be reordered, a low margin sale needs to be investigated or a shipment is overdue. It then lets the relevant staff know what needs to be done via email or a on screen notification. If they still don’t do the job Readysell can keep reminding them and inform management once a task too overdue. A operations dashboard shows the problems that are arising and being resolved in the business during the day. Keeping management and staff aware of the workflow for their area of the business.

Business health monitoring rules and responsibilities can be adjusted like any other data in the system. As a result rules to be deployed across the group to encourage best practice. Also allowing rules to be tailored for each member to suit local conditions.

Business Intelligence for Business Owners

Readysell 8 allows you to take tactical and strategic control of your business by giving you a Business Intelligence Dashboard. This window provides an overview of what is happening as it happens. The Dashboard shows all the key indicators for your business one page. Without needing any reports you can drill down into the graphics and charts (widgets) to identify the causes of problems and successes. Easy to understand colour coded graphics highlight areas of improvement and areas that need attention. There will be a list of key indicators which will be deployed out to customers as standard dashboards. You can also then drag and drop additional charts and tables onto your dashboard.

Relationship Management

Readysell 8 features a new relationship management system that will allow you to track your interactions with customers, suppliers, prospects and other business contacts. Our case-based relationship management system will allow you to keep track of your entire business interactions one place. The contacts system like the rest of the Readysell system links with business health monitoring. New cases can be derived from automatic business rules. For example if a call is overdue or a customer buys less categories than expected in a month a case for follow-up can be generated in the relationship management system.

Inventory and Sales Management

Catalogue and flyer spreadsheets are deployed to members but applied by the members at an appropriate time. Readysell 8 automatically builds up suggested purchase orders as goods are sold or repaired.  We track customer orders from Websphere through all shipments and back orders to the final statement. Readysell 8 includes the ability to utilize state of the art wireless paperless picking devices to improve the efficiency of the warehouse.

One Stop Solution

Readysell 8 provides all the accounting, inventory control, customer relationship tracking and business intelligence needs of the group in a single software package. As customer needs change over time Readysell will adjust our software to satisfy all ERP needs in a single consistent package. Readysell also works with the group to provide training, install assistance and support in a shared and easily accessible form.

What’s Next?

We hope you are as excited about Readysell 8 as we are. We look forward to providing you with more details as they arrive. We are also interested in hearing your valued feedback – if there’s something you think is crucial and want to make sure doesn’t get missed, please email us with your thoughts or leave a comment on our blog.