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.