The Link My Books dashboard may look a little intense at first sight but we tried to make it as intuitive and simple to follow as possible.
There are 5 main sections we'll break down below:
Sorting & Searching
Sorting & Searching
If you are looking for a particular settlement or want to display them differently on your dashboard then you have a few options.
You can sort your settlements by Marketplace, Amount or Date. To do this simply click the ⬍ icon in the column you want to sort by. Clicking it again will sort in the opposite direction.
If you are looking for a particular settlement and know either the Marketplace, Amount or Date then just start typing in the search bar and your settlements will instantly be filtered for that term.
The Status column shows if the settlement is ready to send, sent, processing or has an error.
If there is an error the the Action Required column shown in the image above will indicate what needs to be done to resolve the error.
Here is a list of all of the potential statuses and required actions:
Ready to Send
Ready to send is shown when an invoice has been fully processed and is ready to be sent to Xero.
Awaiting VAT is shown when we are waiting for the Amazon VAT Report to finish processing an invoice. This is generated by Amazon on the 5th of the following month each month.
Sent is shown on invoices that have been sent to Xero, along with the date which they were sent on.
Locked status is shown when a settlement is for a period outside of the last 90 days and you are still on a free trial with us. To unlock the settlement, subscribe to a paid plan.
Processing is shown when a settlement's data is still be processed. This usually only takes a few minutes. This is also shown when you refresh a settlement.
Error is shown on settlements that have failed to process. Usually an error is accompanied by a required action, explaining what is needed to fix the error. If no action is shown, please contact support for further assistance.
Select Marketplace is shown when the marketplace for a settlement is unknown. This occurs when a settlement contains no sales or refunds. You will need to manually select the settlements marketplace. For more info on this error search "unknown marketplace" on help.linkmybooks.com
Enter missing item costs
Enter missing item costs is shown if there are SKUs that have been sold/refunded as part of that settlement, that do not have product costs entered. This only shows if you are using our COGS tracking feature.
Add missing currency
Add missing currency shows if the currency of the settlement is not a currency available in your Xero account. To resolve this you need to add the currency to Xero - you can do this by clicking the required action link in Link My Books. You will need the Premium version of Xero which includes multiple currencies.
The Send to Xero column allows you to send settlements to Xero directly from the dashboard. (You also have the option of viewing them in more detail first before you send them, which we'll cover in the next section)
If a settlement has been sent already then you can re-send it to Xero should you need to do so. If you do re-send settlements then please make sure you delete any duplicates in Xero first.
The Action column contains three settlement actions.
The 🔍icon is the View Settlement action. Clicking it will display that settlements invoice (and bill if you have COGS turned on) and allow you to check them before sending to Xero. Learn more about the View Settlement page here.
The 🔄icon is the Refresh action. You will generally only use this action if you have changed a settlement setting and want to reflect those changes on a settlement.
The 🗑icon is the Hide action. This action hides a settlement from your dashboard. You can also un-hide a settlement that was previously hidden by toggling the Show Hidden button at the top of the dashboard and then clicking on the un-hide action for the hidden settlement.
The last column is the Bulk Actions feature. This allows you to select multiple settlements at a time (or even all settlements) and apply one of two bulk actions to them.
You can refresh settlements in bulk and you can also send settlements in bulk using this action.
To select multiple settlements simply check their bulk action check boxes or to select all settlements, check the top bulk action check box.
Processing times for bulk actions can take a while depending on how many settlements you include. Once a bulk action is complete you will receive a notification.