Project management is a powerful function of SQLWorks CRM, which allows users to collaborate on bigger projects and coordinate work from different areas of your business.

With careful planning, you can use SQLWorks’ Projects tool to more easily collate your team’s efforts towards an overarching goal onto a single dashboard, saving time and money.

‘Projects’ can be accessed under the SQLWorks CRM dropdown in the main navbar (1) and displays your live projects within the list panel (2). Key information and editing buttons for the selected project is displayed at the top of the main window (3).

SQLWorks Projects acts as a collection point for entries from across SQLWorks (including financial elements, tasks, documents and much more) relating to a chosen project, in one place under the correct tab (4). You can create new linked items (of any type) direct from projects by right clicking the correct window from within the project screen, which will also added in the relevant section elsewhere in SQLWorks. For example, a new phone log created inside “projects” will also display in SQLWorks phone logs.

This becomes most powerful in reverse however – when creating new entries elsewhere in SQLWorks, users can tag this as part of a specific project. This is the case for almost any SQLWorks item (including individual lines from quotes, orders or invoices for project costings) which can all be linked to an open Project.

SQLWorks can have multiple project types for managing different sorts of projects at once, each with their own data capture or layout – for example, financial projects may require access to financial entries from SQLWorks Accounts. The SQLWorks team can add new project types for your business on request.

For staged projects, a SQLWorks project can be segmented into saved ‘Stages’ which prompt automatic action when reached, for example emailing a contact or completing a task.

Security groups prevent unauthorised users from accessing restricted projects, or sections within a certain project (for example: confidential data) and this can also be configured on request by the SQLWorks team.

SQLWorks Projects can help you easily gather information and organise stages of a more complex set of related jobs, or pool the work of a larger team in a coordinated way.

 

For more information on SQLWorks CRM tools, contact our team today: http://www.sqlworks.co.uk/contact-us/

 

SQLWorks Purchase Ledger is your main accounting ledger for your ordered items and purchase transactions with other companies.

Purchase Ledger can be found under the ‘Accounts’ heading in the main NavBar (1) and helps manage each stage of the buying process. Any chosen company from your Companies List can be given a purchase Ledger account, and appears in the list panel (2).

In the main window the top panel displays purchasing information relating to that company, including contact details, outstanding invoices and default settings for your purchases from that company, such as a credit limits and nominal codes.

The first ‘All Outstanding’ tab in the lower panel shows a useful summary of your unreconciled payments, customer quotes, outstanding purchase orders and halted items. From left to right tabs headed ‘Orders’, ‘Transactions’ and ‘Unreconciled Items’ (3) allow you to enter each stage of purchasing by clicking on it – keeping a close track on orders placed and received, and money owed.

Unlike your Sales Ledger, items must follow a dual progression to account for both order and invoicing – by logging ‘receive orders’, SQLWorks can support staged deliveries, or other orders that are delivered and invoiced separately by your suppliers.

Users with SQLWorks advanced stock module can track incoming stock items as ‘In Transit’ whilst awaiting delivery, while all users can take account of part orders, expected time of arrival (ETA), and even batch multiple orders as a single ‘delivery.’ ‘Pending Stock’ under your ownership can be allocated, but other SQLWorks functions are restricted to prevent the mis-selling of items not yet physically available for onward dispatch.

Once you have been invoiced, SQLWorks Purchase Ledger allows your business to reconcile multiple orders against a single invoice, flexibly matching your suppliers’ invoicing format. Saved default settings allow SQLWorks to remember other payment conditions for each supplier, such as price rounding and VAT rules, and (with CRM document storage) archive files such as digital copies of supplier invoices.

Payments can be grouped together or processed via BACS, an authorisation system allows larger organisations to set customised purchasing limits for staff, and force users to clear orders past an administrator before being placed. Spending limits can be set by order, outstanding amount, over a chosen time period, or a combination of these for maximum security.

Every reconciled invoice is linked directly by a nominal code to your nominal code category, so SQLWorks always gives an accurate, real-time reflection of your current purchasing finances in your Nominal Ledger.

 

fact sheet sales ledger

SQLWorks Sales Ledger is your main accounting ledger for your quotes, orders, refunds and sales transactions with other companies.

Sales Ledger can be opened under the ‘Accounts’ heading in the main NavBar (1) and includes a full suite of accounting tools. Any company from your Companies List can be given a Sales Ledger account – appearing in the Sales Ledger List (2) for further use.

From here you can prepare quotes, log orders and more, before sending out any invoices and receiving payments from a given company. As you complete sales, your sales move from left to right – starting as disbursements, leads or quotes, becoming orders, and then transactions. The Sales Ledger information for a company is displayed in the Main Window, with ‘Quotes’, ‘Orders’, ‘Transactions’ and more available by clicking the Tabs on the lower right panel (3).

SQLWorks allows you to keep a close track of money owed, customer debts and credit: you can set a Credit Limit for each business along with precise payment terms, deadlines, known company directors, and instruct SQLWorks to email or print invoices as needed. Any custom settings for a given company also allows you to customise SQLWorks reports to reflect this.

Track aged debt with payment terms, turnover, profit, balance history, debt days, stock items bought and other enquiries, all from the account activity section of any given company in your Sales Ledger. If you need to transfer data, electronic data interchange (EDI), allows a user to export orders, or import invoices from other digital sources.

The SQLWorks team can also configure your Sales Ledger to more closely match your sales – adding automatic adjustments for discovered stock, setting up cash account sales or more uncommon types of invoices if needed.

Every financial entry (invoice, receipt or credit note) is linked directly by a nominal code category to your nominal code category, so SQLWorks always gives an accurate, real-time reflection of your current sales finances in your Nominal Ledger.

 

Contact us today about accounting with SQLWorks: 01271 375999 or www.sqlworks.co.uk/contact-us

SQLWorks Stock Ledger tools have been designed to give you complete control over your warehouse(s) and the constant movement of goods necessary for your business to profit.

Stock Ledger can be entered from the Navigation Bar on the left of SQLWorks, under ‘Products’ (1), in one of two versions: ‘Simple’ or ‘Complex’. These different levels of functionality fit your needs and complexity of your business, with complex stock including advanced features such as internal movements, stock locations and batch control.

Opening the Stock Ledger displays a list of every stock item known to your business (2) and allows you to search or filter the list to find the stock item you need. Selecting an item from the list loads its information in the main window for viewing or editing, with movements, orders and other stock functions all found in the lower half of the Main Window.

Keeping count your stock can depend on workflow, so separate figures for ‘Actual’ (available for sale), ‘Pending’ (not yet for sale), ‘Allocated’ (reserved for order), ‘Free’ (warehoused) and ‘Available’ Stock are all recorded (3), to ensure maximum accuracy.

At the top half of the Stock Ledger are tabs governing the attributes of the selected stock item (4) – including a summary of activity, purchase and sale pricing, ordering defaults, analysis categories and other notes.

In the lower half of the Stock Ledger are tabs governing activity on the selected stock item (5) – including a summary dashboard, full stock movement history, linked transactions, deliveries, stock status, any manufacturing/bills of material data, works orders, stock history & linked CRM entries.

‘Stock Audit’ allows SQLWorks to take a snapshot of your stock, producing printed figures for stock checking, calculating a variance factor based on counts from your warehouse team, and permits you to correct your SQLWorks’ Stock Ledger based on this data.

Storing your stock in each warehouse, and its stock bins, can be mapped in any way that you choose: SQLWorks understands where stock is being kept, and keeps track of crates, packs and individual units to ensure that exact quantities are never confused. Buy in crates of a thousand, store as individual units and sell in packs of five – safe in the knowledge that SQLWorks understands the difference. From the ‘Info’ Tab on the toolbar a set of ‘Allowed’ permissions even blocks items from being sold in the Sales ledger in error, and a monthly ‘lock down’ feature can be used to ensure historic data remains an accurate record.

Materials or component parts can be logged as such to avoid miss-selling, and product ‘bills of material’ from those parts saved for accounting of finished products. Any product in SQLWorks can become a kit, built from an unlimited number of sub components in a known construction time, costed as you see fit.

Valuation can vary widely across companies: that’s why SQLWorks understands different types of stock prices: including setting a ‘Default Cost’ for basic use, ‘Average Cost’ across units or materials or ‘Batch Cost’ for varying costs between batches, or a ‘Standard Cost’ for your own asset valuation as needed, and recording sale prices in up to 3 sales currencies (set by the user) to allow for international stock movements.

Batch management gives you the ability to record the item price differently between batches, track shifting margins and buy, store or re-sell the same item deploying different quantities and valuations depending on the batch. All pricing data links directly to your SQLWorks Accounting tools, to ensure that each area of your business software operates as one.

Adjustments to your stock are easily made from the ‘Movements’ button on the toolbar: for example stock movements can be entered in bulk for rapid updating of stock figures, or imported/exported from an external file. For those that need it, Stock Ledger includes an optional serial number system – using unique item numbers SQLWorks can be set to prompt, or even block, users against moving stock without evidencing its serial number. Speak to our team about how the Stock Ledger can best be configured for your businesses workflow.

SQLWorks logs not just your current stock, but your stock history – allowing you to trace movements or individual items long after the event, or monitor stock levels and finances over time. This information is then relayed using graphs for ease of use, and ensures that you always have accurate stock data at your fingertips.

 

For more information, contact our team today: http://www.sqlworks.co.uk/contact/

Navigating SQLWorks

SQLWorks has three areas which form a standard ‘look and feel’ across the software and allow users to easily navigate even the most complex business databases.

Down the left hand side of the page is the Navigation Bar (or ‘NavBar’)(1) – this is the main menu of SQLWorks. Users can expand sections by clicking on the small grey arrows beside the items in the NavBar to enter CRM, Accounts, Stock Control, System Admin and more, or to view and enter subsections.

Above the main list, the Search Bar (2) can be used to search for entries in different modules, finding an entry from lists of phone logs, stock, tasks or other lists in different parts of SQLWorks. If you open a full screen list in SQLWorks the Search Bar will be wider, but users can also adjust the width of the entire list column by clicking and dragging the right hand border.

On the right hand side of the screen is the information relating to the selected entry. Using the Tool Bar (3) users can perform functions related to the selected entry, such as editing, adding a new entry, saving, deleting or loading reports (4.) Your data is then displayed below in the Main Window.

All the SQLWorks menus available can all be customised by Lineal to match the needs of your business, and ensure that you can always find what you need when navigating SQLWorks.

.

For more information, contact our team today: http://www.sqlworks.co.uk/contact/