Catégories

Uncategorized

Exports to Sage 50

By Accounting, Billing, Import and export of data, Uncategorized

Collabox allows you to export to Sage 50 to facilitate your accounting with an external software. Contact us to take advantage of this option.

Exporting invoices

To access the Export to Sage 50 page, first go to the “Accounting” main menu.

Then, go to the left menu in the “Export” section and select the “Export to Sage 50” feature.

Then check all the invoices to be exported.

When you press “Export invoices”, it creates an .IMP file.

Save the file in an easy-to-remember location.

Importing into Sage 50

First, open the “File” tab and scroll down to the “Import/Export” option. Then select “Import Transactions…”.

Choose the second option presented since you want to import sales invoices.

The software recommends to make a backup of the data before importing, free to you.

Then browse your computer to find the .IMP file you saved earlier.

You will then be asked the following questions for each invoice to be imported.

If the client does not exist in Sage 50, you are asked to create it or associate it with an existing client. If a client of the same name exists, you will not see this step, because the client will be assigned to the one of the same name automatically.

Next, you will need to associate each invoice item with the corresponding items/accounts in Sage 50.

If you use the same product numbers in Collabox as your items in Sage 50, you can check the following box in your Sage 50 clients to skip this step:

Modify a client:

Your invoice items will be associated automatically, as long as they exist in Sage 50.

There, the bill is imported!

Watch several tutorials and videos on our Youtube channel and visit our Tips and Tricks section in the Blog to continue your Collabox configuration!

If you have any questions, please contact us and we will be happy to answer you.

info@collabox.com (418) 907-9274

Checkweigher

By Accounting, Accounting report, Checks, Uncategorized

At the end of your year, you will have to produce your trial balance report for your accountant. This report groups all the general ledger entries.

Trial Balance Report

In the main menu at the top, first click on “Report”.

Image showing the top main menu of the Collabox. The "Reports" tab is pointed to with the cursor.

Then, in the left-hand menu, scroll down the page until you find the “Trial Balance” function.

Image showing the "accounting" report section in the left menu. The cursor points to the "Trial Balance" link

Among the options available to you, indicate the correct time interval, then click on “Display”. If necessary, check the boxes to customize the display of the balances.

Image showing an example of the Checkweigher page header. It shows the time interval fields to be filled in, as well as two checkboxes for the custom display of balances.

The trial balance report is now created. To ensure that your organization has its accounting entries in order, the balance in the “Debit” column should be the same as that in the “Credit” column. If this is not the case, as in the following example, you will need to verify that all your invoices and disbursements are balanced. The blog post“Verification” explains how to proceed.

Example of a trial balance report that does not balance.
Example of a trial balance report that does not balance.

Watch several videos on our Youtube channel and visit our Tips and Tricks section in the Documentary Blog to continue using the Collabox!

If you have any questions, please contact us and we will be happy to answer you.

info@collabox.com (418) 907-9274

Automation of budget items

By Accounting, Products, Tips and tricks, Uncategorized

Automating the selection of budget items for your products saves you time and avoids careless mistakes when invoicing. See how to set it up.

Create products

The first step is to create a product. To do this, follow the guidelines presented in the article “Present your products” .

Automation of product budget items

Assigning a budget line item to your product is the first step.

First, go to the desired product sheet. To do so, go to the list of products in the left menu.

Image showing the left menu and the link to the product list.

Then select the desired product.

Here is an image that shows an example of a product list in Collabox. It shows the name of the product, its quantity in inventory and its unit selling price.

When opening the product sheet, stay on the main “Products” tab and scroll to the bottom of the page.

Example of the product page with the product title.

At the bottom of the product configuration page, your budget items are displayed. Choose the one that suits you for the chosen product. Add the hours or the amount expected for this product in the associated box. That’s it!

Example of the product sheet at the bottom of the page where you can choose the right budget item. Here, the tablet is assigned to the single billing item.

Invoice a product

When you invoice a product, the budget item is automatically displayed. No need to think about it anymore!

Example of an invoice for a tablet. The amount of the product is automatically added to the budget item selected in the product master record. Thus, we can see that the automation of product budget items works.

Watch several videos on our Youtube channel and visit our Tips and Tricks section in the Documentary Blog to continue your Collabox configuration!

If you have any questions, please contact us and we will be happy to answer you. info@collabox.com (418) 907-9274