Prima Software Monthly Checklist

These tasks should be performed around the 1st of each month. Running these tasks each month will keep your database updated.

 

Vendor Catalogues

  • Keep an eye out for the ‘New Publication’ pop up and update your catalogues when ready. When approved, catalogues will apply overnight. 
  • Update the SPR best price files in the SPR company > supplier tab.
  • Update any other non-EDI best price files with a terms file.
  • Mark any non-taxable items (coffee, tea, etc) as exempt using the publication grid manager, if needed.

 

Pricing

  • If you use mailers, remember to update them with this month’s pricing.
  • If you use discount bands, use the publication grid manager to reapply the relevant catalogued items to each band to account for newly added items.
  • If you use featured products, update the list of featured items.

 

Products

  • Discontinue any items that no longer have a vendor available so they are no longer available in Prima. If you don’t want to discontinue, you can mark them as unavailable on the web instead.

 

Invoicing

  • Post all purchase invoices for the previous month before closing out the month in QB. Check that none of the invoices have failed to post.
  • Post all sales invoices for the previous month before closing out the month in QB. Check that none of the invoices have failed to post. 
  • Check the drafts folder in Mail for any invoices that have failed to send. 

 

Stock

  • After everything is dispatched and receipted for the previous month (normally done first working day of next month), run the stock valuation report and a physical stock check can be done to confirm quantities on hand. If there are any discrepancies, a stock take can be done in Prima to adjust your inventory levels. 
  • After the stock check, you should make a single journal entry in QB for the difference in stock from previous month (there’s no auto update of inventory/stock) e.g. plus 12,234 Stock.

 

Reports

  • Run the commission report to pay out commission. 
  • Mark invoices as commission paid once the commission report is run.
  • Run the Sales Invoices and Credits with Tax Region summary report for a summary of sales plus the tax owed per region.